If you want to create a new table in an MySQL database that has the same structure, i.e., the same fields (columns) as an existing table, you can use the command below:
create table New_Table like Existing_Table;
New_Table = the name you wish to give to the new table
Existing_Table = the name of the existing table
Remember to use the same case of letters for the existing table name as were actually used for that table name. E.g., if the table name is "Existing_Table" use "Existing_Table" not "existing_table"
