Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.