34,575
社区成员
发帖
与我相关
我的任务
分享
insert into 表1
select * from 表2
where not exists(select * from 表1 where f1=表2.f1 and f2=表2.f2 )
INSERT TABLE1
SELECT * FROM TABLE2 A
WHERE NOT EXISTS(SELECT 1 FROM TABLE1 WHERE CHECKSUM(F1,F2)=CHECKSUM(A.F1,A.F2))
insert t1
select * from t2 where not exists(
select 1 from t1 where field1=t2.f2 and field2=t2.f2)
INSERT TABLE1 SELECT * FROM TABLE2 A WHERE NOT EXISTS(SELECT 1 FROM TABLE1 WHERE CHECKSUM(F1,F2)<>CHECKSUM(A.F1,A.F2))
insert into table2
select * from table1 t
where not exists(select 1 from table2 where f1=t.f1 and f2=t.f2)