Mysql replicates table structure and content to SQL statements in another table _mysql

1. Copy table structure and data to new table

Copy Code code as follows:

CREATE Table New Table
SELECT * from old table

2. Copy table structure to new table only

Copy Code code as follows:

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

That is, let the Where condition not be tenable.

Method Two: (Low version of MySQL does not support, mysql4.0.25 does not support, MYSQL5 has been supported)

Copy Code code as follows:

CREATE Table New Table
Like old table

3. Copy old table data to new table (assuming two table structure)

Copy Code code as follows:

INSERT into new table
SELECT * from old table

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

Copy Code code as follows:

INSERT into new Table (Field 1, Field 2,.......)
SELECT Field 1, Field 2,...... From old table