How to copy the table structure using command lines in mysql

Method 1 for copying the table structure using command lines in mysql. only copy 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 2. copy the TABLE structure and data to the new table create table new table select * FROM the old TABLE www.2cto.com 3. copy the data FROM the old table to the new table (assuming the two tables have the same structure) insert into the new table SELECT * FROM the old table 4. copy the data from the old table to the new table (assuming the two tables have different structures) insert into the new table (Field 1, Field 2 ,.......) SELECT Field 1, Field 2 ,...... FROM old table