SQL statement: About copying table structure and contents to a SQL statement in another table

1. Copy the new table structure and data to the 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

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