DELETE FROM MyTable COMMIT INTERVAL 250 INSERT INTO BTable (ID, SField1, SField2) SELECT ID, SField1, SField2 FROM ATable COMMIT INTERVAL 500