在存储过程中经常会是用到if判断,如下代码:
DROP PROCEDURE
IF EXISTS text;
CREATE PROCEDURE text (OUT rtn INT)
BEGIN
DECLARE LoginId INT DEFAULT 0;
SET rtn = 1;
IF LoginId = 3 THEN
SET rtn = 2;
ELSEIF LoginId = 0 THEN
SET rtn = 3;
ELSE
SET rtn = 4;
END
IF;
END
在存储过程中经常会是用到if判断,如下代码:
DROP PROCEDURE
IF EXISTS text;
CREATE PROCEDURE text (OUT rtn INT)
BEGIN
DECLARE LoginId INT DEFAULT 0;
SET rtn = 1;
IF LoginId = 3 THEN
SET rtn = 2;
ELSEIF LoginId = 0 THEN
SET rtn = 3;
ELSE
SET rtn = 4;
END
IF;
END
转载于:https://my.oschina.net/funmo/blog/535647