Duplicate Table - zhamri/MyClass-MySQL GitHub Wiki

Example 1: Duplicate Table

CREATE TABLE new_table_name AS SELECT * FROM original_table_name;

Example 2: Duplicate Table Structure Only (Without Data)

CREATE TABLE backup_table LIKE original_table;

Example 3: Duplicate Table Structure and Data

CREATE TABLE backup_table LIKE original_table;
INSERT INTO backup_table SELECT * FROM original_table;