[转载] Question 3: merging data, getting rid of dup? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

[转载] Question 3: merging data, getting rid of dup?

[转载] Question 3: merging data, getting rid of dup?# Java - 爪哇娇娃

c*t2003-03-13 08:03

1 楼

【以下文字转载自 Database 讨论区】
【原文由 coconut 所发表】
I obtain table from peer 1 and table from peer 2.
Both peers may have identical rows and both may have different rows.
What is the sql command to merge the two table?
For ex
Peer1:
Name
abc
def
deg
Now add Peer 2 table:
Name
aaa
dddd
def
Can someone show me? Thanks

m*t2003-03-13 08:03

2 楼

define "merge".

【在 c*****t 的大作中提到】

: 【以下文字转载自 Database 讨论区】
: 【原文由 coconut 所发表】
: I obtain table from peer 1 and table from peer 2.
: Both peers may have identical rows and both may have different rows.
: What is the sql command to merge the two table?
: For ex
: Peer1:
: Name
: abc
: def