How do you copy tables for archiving?

[jlee]

Hi

I have a table in a database within phpmyadmin and have a delete sql statement that works fine. However, as well as deleting the entry from table1 I want to copy it to table2 which is basically used as an archive. So the main table has current information and the older records are kept in table2 - is there any way to do this?

Thanks

 

[Rockn]

Make a table that you can archive to that has the same structure as the data you are deleting. Make the query that updates the new table based on the query and when that is done have it delete the entries from the main table.