clone_table.sql

drop procedure if exists clone_table;

delimiter $$
create procedure clone_table ()
begin
  declare n int;
  set n := 0;
  while n < 20 do
    insert destiny_table select
      field_1, 
      field_2
    from origin_table where id > ifnull((select max(id) from destiny_table), 0)
    limit 100000;

    select sleep(10);

    set n := n + 1;
  end while;
end$$

call clone_table();