Duplicate a table

To duplicate a table, simply do the following:

CREATE TABLE newtable LIKE oldtable; 
INSERT newtable SELECT * FROM oldtable;

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents