mysql 存储过程 if条件 判断变量的值是否0

Question

如题所述

Answer 1

mysql> DELIMITER //
mysql> CREATE PROCEDURE TestIfElse
-> (
-> p_val INT
-> )
-> BEGIN
-> IF (p_val = 1) THEN
-> SELECT '1' AS A;
-> ELSEIF (p_val = 2) THEN
-> SELECT '2' AS A;
-> ELSE
-> SELECT 'other' AS A;
-> END IF;
-> END//
Query OK, 0 rows affected (0.05 sec)

上面是一个最简单的 mysql 的
IF / ELSEIF 的例子了...本回答被提问者采纳

Answer 2

if 变量=0 then
end if