Mysql how to backup/copy row from one table to another
INSERT INTO articles_backup
SELECT * FROM articles WHERE articleID="118"
It is so simple we always recommend people do this when updating their database so you always have a backup.
The above inserts the copy into the table "articles_backup" which has an identical structure.
It selects the entry from "articles" where the articleID is "118" but of course you can adapter yours to whatever the situation is.
Tags:
mysql, anotherinsert, articles_backup, select, articles, articleid, quot, updating, database, inserts, identical, selects, entry, adapter,