DELIMITER $$;
DROP PROCEDURE IF EXISTS `myweb`.`test`$$
CREATE PROCEDURE `test`()
BEGIN
declare _done int default 0;
declare _id int default 0;
declare prod int default (select id from luck limit 5,1);
declare cur_mid cursor for
select m.id from member;
declare continue handler for sqlstate '02000' set _done = 1;
open cur_mid;
repeat
fetch cur_mid into _id; #当然也可以有多个
if not _done then
#处理。。可以使用 _id ,
end if;
until _done end repeat;
close cur_mid;
END$$
DELIMITER ;$$