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.........
MySQL how to copy/duplicate a table
CREATE TABLE articles_backup LIKE articles
The code above creates a new table called "articles_backup" which has the exact same structure and attributes as the original articles table.
CREATE TABLE articles_backup SELECT * FROM articles;
The above code does the same thing as the first example, BUT it also copies all of the data.........