Copy table without copying data
MysqlMysql Problem Overview
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?
Mysql Solutions
Solution 1 - Mysql
Solution 2 - Mysql
Try:
CREATE TABLE foo SELECT * FROM bar LIMIT 0
Or:
CREATE TABLE foo SELECT * FROM bar WHERE 1=0
Solution 3 - Mysql
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.
Solution 4 - Mysql
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;