首頁 >後端開發 >php教程 >这段mysql存储过程是否有错误?

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

WBOY
WBOY原創
2016-06-06 20:07:461035瀏覽

<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报错
这段mysql存储过程是否有错误?

回复内容:

<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报错
这段mysql存储过程是否有错误?

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

陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn