mysql 壹個存儲過程中執行第二個遊標時候，則提示遊標沒有打開！

DECLARE flag INT;

DECLARE update_cursor CURSOR

FOR

SELECT stu_name FROM student WHERE id = id;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET flag=1;

SET flag=0;

OPEN update_cursor;

REPEAT /*循環*/

FETCH update_cursor INTO stuName;

SET json = CONCAT(json,',',stuName);

UNTIL flag

END REPEAT;

CLOSE update_cursor ;