Mysql游标使用
DECLARE done INT DEFAULT 0;
DECLARE v_aa,v_bb varchar(512);
#声明游标
DECLARE v_cur CURSOR FOR
SELECT aa,bb
FROM table1
;
#指定游标循环结束时的返回值
DECLARE CONTINUE HANDLER FOR NOT FOUND set done := 1;
OPEN v_cur;
FETCH v_cur INTO v_aa,v_bb;
WHILE done != 1 DO
#do sth.
FETCH v_cur INTO v_aa,v_bb;
END WHILE ;
CLOSE v_cur;