I have 2 tables, table1 and table2.
I have a row in table1 and want to move it to table2 and remove it from table1. Basically, a cut+paste.
I am using php. My current plan is to select from table1, store data in php, insert into table2, then delete from table1. This seems like a very long process.
Is this really the best way to do this?
See Question&Answers more detail:os