drop procedure if exists pro_cursor;
delimiter $$
CREATE PROCEDURE pro_cursor()
BEGIN
declare v_a,v_b,v_c int;
declare done int default 0;
-- 声明游标
declare clist cursor for select a,b,c from tablename;
declare continue handler for not found set done = 1;
-- 打开游标
open clist; set total = 0;
-- 获取结果
-- loop 循环
flag:loop
-- 根据游标当前指向的一条数据
fetch clist into v_a,v_b,v_c;
select v_a,v_b,v_c;//输出游标内容
if done = 1 then
leave flag;
end if;
end loop;
-- 关闭游标
close clist;
END $$
delimiter ;