56,677
社区成员
发帖
与我相关
我的任务
分享
mysql> delimiter //
mysql> CREATE PROCEDURE `t_p_blackmarket`(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
ERROR 1337 (42000): Variable or condition declaration after cursor or handler declaration