sql how to duplicate a table
snippet in sql

sql how to duplicate a table

user9060

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