Shulou(Shulou.com)06/01 Report--

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)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.