Copy table without copying data

Question

CREATE TABLE foo SELECT   FROM bar   copies the table foo and duplicates it as a new table called bar   How can I copy the schema of foo to a new table called bar without copying over the data as well

User · Answer

Try   CREATE TABLE foo LIKE bar    so the keys and indexes are copied over as  well   Documentation

User · Answer

SHOW CREATE TABLE bar    you will get a create statement for that table  edit the table name  or anything else you like  and then execute it   This will allow you to copy the indexes and also manually tweak the table creation   You can also run the query within a program

User · Answer

Try   CREATE TABLE foo SELECT   FROM bar LIMIT 0   Or   CREATE TABLE foo SELECT   FROM bar WHERE 1 0

User · Answer

Only want to clone the structure of table   CREATE TABLE foo SELECT   FROM bar WHERE 1   2    Also wants to copy the data   CREATE TABLE foo as SELECT   FROM bar

[mysql] Copy table without copying data

Examples related to mysql