Copy table structure and data SQL statements

Transfer from csdnhttp://blog.csdn.net/johnny_depp/article/details/2179153

1. Copy table structure and data to a new table

CREATE table new Table SELECT * from old table

2. Copy the table structure to the new table only

CREATE table new Table SELECT * from old table WHERE 1=2

That is, let the where condition not be established.

Method Two: (provided by Tianshibao)

CREATE table new table like old table

3. Copy the data from the old table to the new table (assuming two table structures)

INSERT into new table SELECT * from old table

4. Copy the data from the old table to the new table (assuming that the two table structures are different)

INSERT into new table ( field 1, field 2,....... ) SELECT field 1, field 2,...... from old table

Copy table structure and data SQL statements