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.
Tags:
mysql, duplicate, tablecreate, articles_backup, articles, creates, quot, attributes, select, copies,