mysql> delimiter //
mysql> CREATE PROCEDURE `t_p_blacket`(in uid int, in bid int, in paynum int, in type int, out state int)
-> begin
-> declare exit handler for SQLEXCEPTION rollback;
-> declare _bid int;
-> declare _sid int;
-> declare _uid int;
-> declare _uname varchar(50) default '';
-> declare _paynum int default 0;
-> declare _payprice float default 0.000;
-> declare _type int;
->
->
-> start TRANSACTION;
->
-> COMMIT;
-> end;
-> //
ERROR 1337 (42000): Variable or condition declaration after cursor or handler declaration
mysql> CREATE PROCEDURE `t_p_blacket`(in uid int, in bid int, in paynum int, in type int, out state int)
-> begin
-> declare exit handler for SQLEXCEPTION rollback;
-> declare _bid int;
-> declare _sid int;
-> declare _uid int;
-> declare _uname varchar(50) default '';
-> declare _paynum int default 0;
-> declare _payprice float default 0.000;
-> declare _type int;
->
->
-> start TRANSACTION;
->
-> COMMIT;
-> end;
-> //
ERROR 1337 (42000): Variable or condition declaration after cursor or handler declaration
解决方案 »
- 想了很久,没想到好的解决方案,大家讨论下。
- Parameter number 8 is not an OUT parameter
- 中文分词服务器(C语言开发+词库+源代码),最大特色可以让javascript来调用!当然也可以让其他任何语言来调用
- MySQL常用的复杂或者表关联查询语句
- 【【【高分求救】】
- 第一次写mysql procdure,问题实在奇怪
- .net与mysql 的连接错误
- 执行速度很慢很慢啊 请大神帮忙啊 给出表结构了
- 求一条查询语句
- mysql 游标和内部select into同时发生 SQLSTATE '02000'的问题
- sql语句检索最大列
- mysql数据量很大时,CPU占用率很高,如何优化
mysql> CREATE PROCEDURE `t_p_blacket`(in uid int, in bid int, in paynum int, in type int, out state int)
-> begin
-> declare exit handler for SQLEXCEPTION rollback;
-> declare _bid int;
-> declare _sid int;
-> declare _uid int;
-> declare _uname varchar(50) default '';
-> declare _paynum int default 0;
-> declare _payprice float default 0.000;
-> declare _type int;
->
->
-> start TRANSACTION;
->
-> COMMIT;
-> end;
-> //
ERROR 1337 (42000): Variable or condition declaration after cursor or handler declaration
為啥提示介個錯誤涅?
-> declare exit handler for SQLEXCEPTION rollback;
-> declare _bid int;
-> declare _sid int;
-> declare _uid int;
-> declare _uname varchar(50) default '';
-> declare _paynum int default 0;
-> declare _payprice float default 0.000;
-> declare _type int; ------------------------->
-> begin
->
-> declare _bid int;
-> declare _sid int;
-> declare _uid int;
-> declare _uname varchar(50) default '';
-> declare _paynum int default 0;
-> declare _payprice float default 0.000;
-> declare _type int;
declare exit handler for SQLEXCEPTION rollback; -- 放在这