move table row

[gurechan]

Not sure if this can be done, but is there a way to move a row from one mysql table to another (table structure is identical) using php?

[bubblegum.anarchy]

The INSERT SELECT statement, something like:

 

mysql_query("INSERT INTO new_table SELECT * FROM old_table");