mysql exit handler_mysql高级 存储过程[2] handler 的continue 和 exit 还有[undo]

上一篇中， 的多取出， 逻辑错误：

create procedure p15()

begin

declare row_gid int;

declare row_num int;

declare row_name varchar(20);

declare you int default 1; -- 标志

declare getgoods cursor for select gid,name,number from goods;

declare continue handler for NOT FOUND set you := 0; -- 如果为空设置为0

open getgoods;

repeat

fetch getgoods into row_gid,row_name,row_num;

select row_num,row_name;

until you=0 end repeat; -- 标志是否为0

close getgoods;

end$

/*

逻辑错误多取出一行

*/

create procedure p16()

begin

declare row_gid int;

declare row_num int;

declare row_name varchar(20);

declare you int default 1; -- 标志

declare getgoods cursor for select gid,name,number from goods;

declare exit handler for NOT FOUND set you := 0; -- 如果为空设