MySQL uses SQL statements to copy tables

1. Copy the table structure and data to the new table create table new table select * from old table this method will copy all the content in oldtable, of course we can use Delete from newtable; to delete. However, the worst thing about this method is that the new table does not have the primary key, extra (auto_increment) and other attributes of the old table. You need to use "alter" to add it yourself, and it is easy to make a mistake. 2. copy only the table structure to the new table create table new table select * from old table where 1 = 2 or create table new table like old table 3. copy the data from the old table to the new table (assuming the two tables have the same structure)) insert into new table select * from old table 4. Copy data from old table to new table (assuming the two tables have different structures) insert into new table (Field 1, field 2 ,.......) select Field 1, Field 2 ,...... from old table 5. You can copy Table 1 structure to table 2 select * into Table 2 from table 1 where 1 = 2 6. You can copy all Table 1 content to table 2 select * into table 2 from table 1 7, show create table old table; this will list the creation commands of the old table. We only need to copy the command and change the table name to create a table with the same name.