[MySQL] How to clone table To inherit all table definitions CREATE TABLE new_table LIKE original_table; To copy the data, you’ll need INSERT INTO new_table SELECT * FROM original_table; https://popsql.com/learn-sql/mysql/how-to-duplicate-a-table-in-mysql