[Resolved] Copy entire row of MySQL data from one table to another

[cbj4074]

Hey, everyone,

I have two identical MySQL tables. One is used to store temporary session data, and one is used to make that data permanent once the user has completed a series of several forms.

I'm wondering if there is any easy way to "copy" an entire row of data from one table to another without having to store of all the row values in temporary PHP variables and using two statements (a SELECT and then an INSERT).

Any ideas?

Thanks!

[Drakla]

INSERT INTO othertable SELECT * FROM firsttable WHERE something = somecondition;

[cbj4074]

Exactly what I was looking for. Thanks so much, Drakla 🙂