在存储过程中经常会是用到if判断，如下代码：
DROP PROCEDUREIF EXISTS text;CREATE PROCEDURE text (OUT rtn INT)BEGINDECLARE LoginId INT DEFAULT 0;SET rtn = 1;IF LoginId = 3 THENSET rtn = 2;ELSEIF LoginId = 0 THENSET rtn = 3;ELSESET rtn = 4;ENDIF;END
本文共 270 字，大约阅读时间需要 1 分钟。
在存储过程中经常会是用到if判断，如下代码：
DROP PROCEDUREIF EXISTS text;CREATE PROCEDURE text (OUT rtn INT)BEGINDECLARE LoginId INT DEFAULT 0;SET rtn = 1;IF LoginId = 3 THENSET rtn = 2;ELSEIF LoginId = 0 THENSET rtn = 3;ELSESET rtn = 4;ENDIF;END
转载于:https://my.oschina.net/funmo/blog/535647