SQL data table copy statement

1. Use

Note that this method can automatically create tables, but does not create primary keys.

For example, the select column into target table name from source table name

The code is as follows:	Copy code
Select * into wx from zl

2. If the target table already exists, use

In this case, it is best to cancel the automatic growth of the auto-growth column in the target table without causing an error.

For example, insert into table (column) select (column) from table

The code is as follows:	Copy code
Select into wx (w, x) select z, l from zl