Use SQL statements to merge two tables in the database into one table
Select * into new table name from (select * from T1 union all select * from T2)
This statement allows you to append the merged data to a new table.
Do not merge duplicate data select * from T1 union all select * from T2
Merge duplicate data select * from T1 union select * from T2
Two tables, Table 1, Table 2
If you want to add the data from Table 1 to Table 2, you can use the following statement
Insert into Table 2 (Field 1, Field 2) select Field 1, Field 2 from b1
Note that all field names must be written clearly, and automatic numbering is not allowed. To merge automatic numbering fields, one algorithm must be rewritten and one record after another.
1 insert into b1 select * from b2
2 select * into newtable from (select * from b1 union all select * from b2)
