56,679
社区成员
发帖
与我相关
我的任务
分享
delimiter $$
create procedure p()
begin
set @f=0, @r=10;
prepare st from 'insert into t2 select* from t1 limit ?,10';
while @r=10 do
execute st using @f;
select found_rows(), row_count() into @f, @r;
end while;
deallocate prepare st;
end$$
delimiter ;
call p;
drop procedure if exists p;