如何合并两个 MySQL 表?

2021-11-20 00:00:00 merge sql mysql

如何合并两个结构相同的 MySQL 表?

How can I merge two MySQL tables that have the same structure?

两个表的主键会冲突，所以我已经考虑到了.

The primary keys of the two tables will clash, so I have take that into account.

推荐答案

你也可以试试:

INSERT IGNORE
  INTO table_1 
SELECT *
  FROM table_2
     ;

它允许 table_1 中的那些行取代 table_2 中具有匹配主键的那些行，同时仍然插入具有新主键的行.

which allows those rows in table_1 to supersede those in table_2 that have a matching primary key, while still inserting rows with new primary keys.

或者，

REPLACE
   INTO table_1
 SELECT *
   FROM table_2
      ;

将使用 table_2 中的相应行更新 table_1 中已有的那些行，同时插入具有新主键的行.

will update those rows already in table_1 with the corresponding row from table_2, while inserting rows with new primary keys.

相关文章