Duplicate table with MySQL

Just replace the new_table with the name of your new table and existing_table with the table you want to duplicate

CREATE TABLE new_table SELECT * FROM existing_table

Leave a comment