27、MySQL的游标

1、什么是游标
在存储过程中，根据需要对数据集合进行前后浏览的一种应用。cursor
2、使用/创建游标

create procedure pro_cursor()
begin
  declare ordernumbers cursor
  for 
  select order_num from orders;
  open ordernumbers;
  close ordernumbers;
end;

3、浏览数据

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