哦哦、这个我现在修改的:BEGIN DECLARE id VARCHAR(100);DECLARE table_name_cursor CURSOR FOR SELECT log_id FROM cancelOrder; declare done int default false; declare continue handler for not found set done=true; OPEN table_name_cursor; repeat FETCH table_name_cursor INTO id; until done end repeat; CLOSE table_name_cursor;END 但是都是只取第一个就退出了,这个怎么回事?
declare done int default false;这部分应该在declare cursor 前面吧
DECLARE
id VARCHAR(100);DECLARE
table_name_cursor CURSOR FOR SELECT
log_id
FROM
cancelOrder;
declare done int default false;
declare continue handler for not found set done=true;
OPEN table_name_cursor;
repeat
FETCH table_name_cursor INTO id;
until done end repeat;
CLOSE table_name_cursor;END 但是都是只取第一个就退出了,这个怎么回事?