这段mysql存储过程是否有错误?

DELIMITER //
create procedure largest_orderout largest_id int
BEGIN declare this_id int; declare this_amount float; declare l_amount float default 0.0; declare l_id int; declare done int default 0; declare c1 cursor for select orderid,amount from orders; declare continue handler for SQLSTATE 02000 set done = 1; open c1; repeat fetch c1 into this_id,this_amount; if not done THEN if this_amount > l_amount THEN set l_amount=this_amount; set l_id=this_id; end IF; end if; until done end repeat; close c1; set largest_id = l_id;
END
//
DELIMITER ;

代码如上,在navicat报错

已解决,是代码有遗漏,末尾缺少斜杠

发表评论

电子邮件地址不会被公开。 必填项已用*标注