appending data

[Alira]

Hi All!

What would be the best way for "removing from table1 - appedning to table2" couple of thousand records at a time?

Have a great day!

 

[fluteplr]

Assuming the table structures are the same.

insert into table2
select * from table1

You can add field lists if needed as well as a where clause on the select.

Deletes are just

delete from table1 where (enter your where clause here)