我初学啊,找了半天不知道是什么错误,帮我看看,谢谢
mysql> CREATE PROCEDURE p25(OUT return_val INT)
-> BEGIN
-> DECLARE a,b INT;
-> DECLARE cur_1 CURSOR FOR SELECT s1 FROM t;
-> DECALRE CONTINUE HANDLER FOR NOT FOUND;
-> SET b=1;
-> OPEN cur_1;
-> REPEAT
-> FETCH cur_1 INTO a;
-> UNTIL b=1
-> END REPEAT;
-> CLOSE cur_1;
-> SET return_val=a;
-> END;//
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'CONTI
NUE HANDLER FOR NOT FOUND;
SET b=1;
OPEN cur_1;
REPEAT
FETCH cur_1 I' at line 5
mysql> CREATE PROCEDURE p25(OUT return_val INT)
-> BEGIN
-> DECLARE a,b INT;
-> DECLARE cur_1 CURSOR FOR SELECT s1 FROM t;
-> DECALRE CONTINUE HANDLER FOR NOT FOUND;
-> SET b=1;
-> OPEN cur_1;
-> REPEAT
-> FETCH cur_1 INTO a;
-> UNTIL b=1
-> END REPEAT;
-> CLOSE cur_1;
-> SET return_val=a;
-> END;//
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'CONTI
NUE HANDLER FOR NOT FOUND;
SET b=1;
OPEN cur_1;
REPEAT
FETCH cur_1 I' at line 5
解决方案 »
- mysql数据库问题
- 一台机子启用多个mysql ,Fatal error: Please read "Security" section of the manual to find
- 我本地的phpmyadmin,可以管理我的虚拟主机上的mysql吗?
- 两个表的对比问题
- 请教各位,有一数据表中的字段有部分为中文,偶现在要把所有中文的替换掉怎么办?
- 请教朋友们一个mysql中的delete语句的格式
- mysql 让扬声器发出声音
- MySQL许可政策与许可示范翻译稿 哪里有???
- Mysql 行转列 求助 40
- 本地机器如何判断远程机器是否安装MYSQL,如果安装了如何检测某个数据库存在
- 关于linux下mysql的安装问题
- 如何查看和修改mysql数据库的字符集
但还是一样要报错,不知道为什么
delimiter ||
CREATE PROCEDURE p25(OUT return_val INT)
BEGIN
DECLARE a,b INT;
DECLARE cur_1 CURSOR FOR SELECT s1 FROM t;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET b = 1;
OPEN cur_1;
REPEAT
FETCH cur_1 INTO a;
UNTIL b=1 END REPEAT;
CLOSE cur_1;
SET return_val=a;
END||
delimiter ;