insert ignore duplicate key

Insert into T1
select * from T2  
where NOT EXISTS (select 1 from T1 X where X.GUID=T2.GUID);

posted @ 2018-11-09 14:41  kakaisgood  阅读(328)  评论(0)  编辑  收藏  举报