mysql 多个if语句_MySQL if语句【6】

USE yiibaidb;

DROP PROCEDURE

IF EXISTS get_customerLevel;

DELIMITER $$

CREATE PROCEDURE get_customerLevel (

IN customerNum INT (10),

OUT customerLevel VARCHAR (10)

)

BEGIN

DECLARE creditlim DOUBLE ;

SELECT

creditlimit INTO creditlim

FROM

customers

WHERE

customerNumber = customerNum ;

IF creditlim > 50000 THEN

SET customerLevel = 'PLATINUM' ;

ELSEIF creditlim <= 50000

AND creditlim > 10000 THEN

SET customerLevel = 'GOLD' ;

ELSEIF creditlim <= 10000 THEN

SET customerLevel = 'SILVER' ;

END

IF ;

END$$

DELIMITER ;

CALL get_customerLevel (124 ,@customerLevel) ;

SELECT@customerLevel ;