Copy table structure to new table?

[developer]

Hello! 🙂

I have a table, I need the same structure to another table in the same database.

Is there any way to make a copy of the table structure and save it under anoher name? ( or any other way)

I do use phpMyAdmin.

Thanks in advance.

[LordShryku]

If you have MySQL 4.1, you could use

CREATE TABLE new_table LIKE old_table;

If not, using phpMyAdmin, you can export the structure of the old table, copy, change the table name, then paste the SQL back in.

[developer]

Done! 🙂

Thanks for the help LordShryku 🙂

Have a great week!