mysql-游标

游标

1.1 创建游标

create procedure processorders()
begin
 declare ordername CURSOR
 for 
 select order_num from orders;
end;

declare 用来声明和定义游标。存储过程结束，游标就消失了。

1.2 打开和关闭游标

open ordername;
close ordername;

如果没有明确关闭游标，将达到end自动关闭。

1.3 使用游标

create procedure processorders()
begin
declare done boolean default 0;
declare o int;
declare ordername CURSOR
 for 
 select order_num from orders;
declare continue handler for SQLSTATE '02000' set done=1;
open ordername;
repeat
fetch ordername into o
until done end repeat;
close ordername;
end;