<body>
<code>DELIMITER //create procedure largest_order(out 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 ;</code>
代码如上,在navicat报错
*本文来源gaodai#ma#com搞@代~码^网+搞代gaodaima码
回复内容：
<body>
<code>DELIMITER //create procedure largest_order(out 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 ;</code>
代码如上,在navicat报错
已解决，是代码有遗漏，末尾缺少斜杠
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：这段mysql存储过程是否有错误？
转载请注明原文链接：这段mysql存储过程是否有错误？
