Question

I would like merge 2 MySQL tables without adding the same lines. I have 2 tables with the sames columns but not the same row, such as.

table_1
+-------+--------+------+
| Name  | ResNum | Code | 
+-------+--------+------+
| User1 | 25BAM8 | PAR1 |
| User2 | E26J09 | COP3 |
+-------+--------+------+

table_2
+-------+--------+------+
| Name  | ResNum | Code | 
+-------+--------+------+
| User1 | 25BAM8 | PAR1 |
| User3 | 34VNS2 | PAR1 |
| User4 | EZQVG5 | COP3 |
+-------+--------+------+

我想,在将表2合并到表1时,就这样:

table_1
+-------+--------+------+
| Name  | ResNum | Code | 
+-------+--------+------+
| User1 | 25BAM8 | PAR1 |
| User2 | E26J09 | COP3 |
| User3 | 34VNS2 | PAR1 |
| User4 | EZQVG5 | COP3 |
+-------+--------+------+

我已经与INSERT IGNORE INTO和REPLACE INTO指挥部一道尝试过,但像以下那样复制了现有各行:

table_1
+-------+--------+------+
| Name  | ResNum | Code | 
+-------+--------+------+
| User1 | 25BAM8 | PAR1 |
| User1 | 25BAM8 | PAR1 |
| User2 | E26J09 | COP3 |
| User3 | 34VNS2 | PAR1 |
| User4 | EZQVG5 | COP3 |
+-------+--------+------+

希望得到任何帮助。

Answer 1

一种容易的解决办法是,在表_1:

CREATE UNIQUE INDEX unique_name ON table_1(Name)

转拨实际浏览量,使用SINET INSERT:

INSERT INTO table_1(Name, ResNum, Code) SELECT Name, ResNum, Code FROM table_2.

之后,联合国协会请求指数下降:

DROP INDEX unique_name ON table_1

Answer 2

如果这些领域的独一无二之处对你很重要,那么你就需要确定联合国协会的要求。

然后,你可以做<条码>。 INSERT ......SlectT,没有问题,你今后就获得了这方面的问题。

Answer 3

The below query should work fine.

SELECT * FROM TABLE_1 T1,TABLE_2 T2
WHERE T1.NAME = T2.NAME
UNION
SELECT * FROM TABLE_1 T1, TABLE_2 T2
WHERE T1.NAME != T2.NAME

友情链接