Welcome Guest, Not a member yet? Register   Sign In
Moving 1 database row to another Table

What's the simplest way to move an entire table row into another table? Perhaps there's a mySQL command?
Or will I have to query the current table to gather all the fields, insert them into the other table, then go back in the first table and delete that row?

There is a MySQL command:

INSERT INTO smf_members (ID_MEMBER, memberName, emailAddress, passwd, dateRegistered, lastLogin ) SELECT id, name, email, password, creationtime, lastClickTime FROM classifieds_classifiedsuser WHERE COL1=COL1

Then you would do a separate delete command using your where clauses.

Theme © iAndrew 2016 - Forum software by © MyBB