展开全部
语法错误。
MySQL 里面。
IF 条件 THEN
......
END IF
的。
例如: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> call TestIfElse(1);
-> //
+---+
|32313133353236313431303231363533e78988e69d8331333332623938 A |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> call TestIfElse(2);
-> //
+---+
| A |
+---+
| 2 |
+---+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> call TestIfElse(3);
-> //
+-------+
| A |
+-------+
| other |
+-------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql>
你那里少了一个 THEN