How to Duplicate a Table

In MySQL you can duplicate a table, but you need to use a different table name. To duplicate the schema and content of a table just do:

create table employee_new as select * from employee;

If you want to create a new table replicating the schema, but leaving the table empty, you can do:

create table employee_new as select * from employee limit 0;

IN THIS PAGE