There are two table data replication statements: 1. the INSERTINTOSELECT statement format is: INSERTINTOtable2 (field1, field2 ,...) SELECTvalue1, value2 ,... FROMtable1 requirement: the target table table2 must exist here because the target table ta... there are two table data replication statements:
1. insert into select statement
Statement format: insert into table2 (field1, field2,...) SELECT value1, value2,... FROM table1
Requirement: the target table table2 must exist.
As Table 2 already exists in the target table, we can insert constants in addition to the field of Table 1 in the source table.
2. select into from statement
Statement format: SELECT vale1, value2 INTO table2 FROM table1
Requirement: the target table table2 does not exist.
Table 2 is automatically created during insertion, and the specified field data in Table 1 is copied to Table 2.