56,687
社区成员
发帖
与我相关
我的任务
分享
begin
declare v_a text;
declare v_b text;
declare v_c text;
declare done int;
declare cursor for select * from table;
declare continue handler for sqlstate '02000' set done = 1;
open cursor ;
repeat
fetch cursor into v_a,v_b,v_c;
insert tablea (a,b,c) values (v_a,v_b,v_c);
until done end repeat;
close cursor;
end