如何合并两个MySQL表? [英] How can I merge two MySQL tables?
本文介绍了如何合并两个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
;
允许表_1中的行替换表_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.
这篇关于如何合并两个MySQL表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文