Copy MySQL Table

Copy MySQL table in two steps

Step 1 create table structure:

CREATE TABLE new_table LIKE old_table;

Step 2 fill in data:

INSERT INTO new_table SELECT * FROM old_table;