MySQL copy table to another table

1. Copy table structure and data to new table    CREATE table new Table select * from old table 2. Only copy table structure to new Table Method 1: (Low version of MySQL is not supported, mysql4.0.25 not supported, MYSQL5 already supported)    CREATE table new table like old Table Method 2:    CREATE table New Table select * from old table limit 0 Method 3:    CREATE table New Table select * from old table where not Conditions of Incorporation 3. Copy the data from the old table to the new Table 1, (assuming two table structures)    INSERT into new table SELECT * from old table 2, (assuming two table structure is not    the same) insert into new table (Field 1, Field 2,.......) Select Word Segment 1, field 2,...... from old table

MySQL copy table to another table