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;
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;