MySQL - Duplicate Table

Question

I need to duplicate a table in MySQL, making the new table empty. That is, I need to copy only the structure of the existing table to the new one.

Answer 1

Try creating the LIKE syntax of the create table.

create table users2 like users; 

This should give you an empty table (users2) with the same structure as the original (users).

Answer 2

There is also another way to create an empty table as an existing table, and you can also use the following command

 create table a select * from users2 limit 0, 0;