SQL Duplicate a table


Example

To duplicate a table, simply do the following:

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