MySQL stored the usage of if statements
MySQL has stored the usage of if statements, and MySQL IF statements allow you to execute a set of SQL statements based on a condition or value result of an expression.
1Perfect if structure IF expression THEN statements; END IF; IF expression THEN
Statements
ELSE
Else-statements
END IF
IF expression THEN
Statements
ELSEIF elseif-expression THEN
Elseif-statements
ELSE
Else-statements
END IF
2 DELIMITER if instance $$
CREATE PROCEDURE GetCustomerLevel (
In p_customerNumber int (11)
Out p_customerLevel varchar (10))
BEGIN
DECLARE creditlim double
SELECT creditlimit INTO creditlimFROM customersWHERE customerNumber = paired customerNumberterif creditlim > 50000 THEN
SET p_customerLevel = 'PLATINUM'
ELSEIF (creditlim = 10000) THEN
SET p_customerLevel = 'GOLD'
ELSEIF creditlim < 10000 THEN
SET p_customerLevel = 'SILVER'
END IF
END$$
If is used in stored procedures to increase hands-on ability.
The article is from www.dc3688.com.
