DBMS/MySQL
[MYSQL] π Select into λ¬Έλ² μ 리
μΈν_
2022. 6. 18. 06:40
Select into
MySQLμμ select into λ¬Έλ²μ μ¬μ©μ μ μ λ³μμ select ν νλ κ°μ μ§μ΄λ£κΈ° μν΄μ μ¬μ©λλ€.
λ³΄ν΅ μ€ν μ΄λ νλ‘μμ λ΄μμ μ¦κ²¨ μ°μΈλ€.
BEGIN
DECLARE a int;
DECLARE b int;
select user_name, user_id into a, b from user_table
-- user_tableμμ μ‘°νν user_nameκ³Ό user_id νλκ°μ μμμ μ μΈν μ§μλ³μ a, bμ κ°κ° λ£λλ€.
END$$
DELIMITER $$
CREATE PROCEDURE GetCustomerLevel(
IN p_customerNumber int(11),
OUT p_customerLevel varchar(10))
BEGIN
DECLARE creditlim double;
SELECT creditlimit INTO creditlim -- selectν κ²°κ³Ό creditlimit νλ κ°μ μμμ μ μΈν μ§μλ³μ creditlimμ λ£λλ€
FROM customers
WHERE customerNumber = p_customerNumber;
-- κ·Έλ κ² selectν κ°μ λμ
ν λ³μλ₯Ό μ΄μ©νμ¬ μ½λ©νλ€.
IF creditlim > 50000 THEN
SET p_customerLevel = 'PLATINUM';
ELSEIF (creditlim <= 50000 AND creditlim >= 10000) THEN
SET p_customerLevel = 'GOLD';
ELSEIF creditlim < 10000 THEN
SET p_customerLevel = 'SILVER';
END IF;
END$$
DELIMITER ;