merge into dz_zzxx_test t1 using (select * from dz_zzxx) t2 on (t1.zzbh=t2.zzbh) when matched then update set t1.SSXQ=t2.ssxq, t1.JLX=t2.jlx, t1.MPQZ=t2.mpqz, t1.MPH=t2.mph, t1.MPHZ=t2.mphz, t1.FH=t2.fh when not matched then insert ( t1.ZZBH,t1.SSXQ,t1.JLX,t1.MPQZ,t1.MPH,t1.MPHZ,t1.FH ) values ( t2.ZZBH,t2.SSXQ,t2.JLX,t2.MPQZ,t2.MPH,t2.MPHZ,t2.FH );dz_zzxx表数据量比较大有170万条数据,所以同步的时候很慢
(select * from dz_zzxx) t2
on (t1.zzbh=t2.zzbh)
when matched then update set
t1.SSXQ=t2.ssxq,
t1.JLX=t2.jlx,
t1.MPQZ=t2.mpqz,
t1.MPH=t2.mph,
t1.MPHZ=t2.mphz,
t1.FH=t2.fh
when not matched then insert
(
t1.ZZBH,t1.SSXQ,t1.JLX,t1.MPQZ,t1.MPH,t1.MPHZ,t1.FH
)
values
(
t2.ZZBH,t2.SSXQ,t2.JLX,t2.MPQZ,t2.MPH,t2.MPHZ,t2.FH
);dz_zzxx表数据量比较大有170万条数据,所以同步的时候很慢