mysql insert and buffers, is this possible

Question

how is this possible

first i do insert into table2 select * from table1 where table1.id=1 ( 50k records should be moved 6 indexes has to be updated )

second delete from table1 where id=1 ( 50k records are removed )

How is it possible that only 45k of records are moved?

Im scratching my head over this and cant find a right answer Is it possible that the insert is still active and delete already started

Answer 1

why dont you just call a stored procedure - would be much cleaner !

delimiter ;
drop procedure if exists move_data;

delimiter #
create procedure move_data
(
  in p_table_id int unsigned
)
begin
  set autocommit = 0;
  insert into table2 select * from table1 where table1.id = p_table_id;
  delete from table1 where id = p_table_id;
  commit;       
end #

delimiter ;

call move_data(1);  

Answer 2

soap in my eyes, not slept well. Wanna thank you all for your effort.