复制表而不复制数据

CREATE TABLE foo SELECT * FROM bar

复制表 foo并将其复制为名为 bar的新表。

如何将 foo的模式复制到一个名为 bar没有的新表中，以及复制数据？

160299 次浏览

小开

最佳答案

Try:

CREATE TABLE foo SELECT * FROM bar LIMIT 0

Or:

CREATE TABLE foo SELECT * FROM bar WHERE 1=0

小开

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.

小开

Try

CREATE TABLE foo LIKE bar;

so the keys and indexes are copied over as, well.

小开

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;