Home > Backend Development > PHP Tutorial > 这段mysql存储过程是否有错误?

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

WBOY
Release: 2016-06-06 20:07:46
Original
1045 people have browsed it

<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>
Copy after login
Copy after login

代码如上,在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>
Copy after login
Copy after login

代码如上,在navicat报错
这段mysql存储过程是否有错误?

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

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template