mysql存储过程游标的使用
begin
DECLARE cur1 CURSOR for select userid,susername from user_student;
DECLARE done INT DEFAULT 0; #repeat结束标识
DECLARE uname varchar(40);
DECLARE uid varchar(20);
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; #表示当循环列表完毕后将done设置为1
OPEN cur1;
REPEAT
FETCH cur1 INTO uid,uname;
IF NOT done THEN
#业务逻辑
end if;
UNTIL done END REPEAT;
close cur1;
end;