mysql的游标处理_mysql游标处理

DELIMITER $$

DROP PROCEDURE IF EXISTS `proc_cur`$$

CREATE PROCEDURE `proc_cur`()

BEGIN

DECLARE done INT DEFAULT 0;

DECLARE myid INT;

DECLARE cur1 CURSOR FOR SELECT id FROM aa;

DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;

OPEN cur1;

REPEAT

FETCH cur1 INTO myid;

...

UNTIL done END REPEAT;

CLOSE cur1;

END$$

DELIMITER ;

注意问题：

1.定义要连在一起，否则要出错

DECLARE cur1 CURSOR FOR SELECT id FROM aa;

DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;

2.done的值需要初始化，在循环中不需要改它的值