Procediments emmagatzemats. Continuació

IF. Condicionals

• https://www.mysqltutorial.org/mysql-if-statement/

Ús del IF-ELSEIF-ELSE:

DELIMITER $$

CREATE PROCEDURE GetCustomerLevel(
    IN  pCustomerNumber INT, 
    OUT pCustomerLevel  VARCHAR(20))
BEGIN
    DECLARE credit DECIMAL DEFAULT 0;

    SELECT creditLimit 
    INTO credit
    FROM customers
    WHERE customerNumber = pCustomerNumber;

    IF credit > 50000 THEN
        SET pCustomerLevel = 'PLATINUM';
    ELSEIF credit <= 50000 AND credit > 10000 THEN
        SET pCustomerLevel = 'GOLD';
    ELSE
        SET pCustomerLevel = 'SILVER';
    END IF;
END $$

DELIMITER ;

I per provar el procediment:

CALL GetCustomerLevel(447, @level);
SELECT @level;

CALL GetCustomerLevel(447, @level); 
SELECT @level;

sentència CASE

• https://www.mysqltutorial.org/mysql-case-statement/

Bulces LOOP

• https://www.mysqltutorial.org/stored-procedures-loop.aspx

Bucles WHILE LOOP

• https://www.mysqltutorial.org/mysql-stored-procedure/mysql-while-loop/

Bucles REPEAT LOOP

• https://www.mysqltutorial.org/mysql-stored-procedure/mysql-repeat-loop/

Sentència LEAVE

• https://www.mysqltutorial.org/mysql-stored-procedure/mysql-leave/

---

creat per Joan Quintana Compte, març 2022