当然会有重复了,要不重复就:
inset into table1
select a,b from table2 x
where not exists (
select a,b from table1 y
where y.a=x.a
and y.b=x.b
)
inset into table1
select a,b from table2 x
where not exists (
select a,b from table1 y
where y.a=x.a
and y.b=x.b
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货