CNM:MERGE INTO"/>
CNM:MERGE INTO
你大爷的,全网百度,就是没人知道,不适应 when matched then 会不会死。下面语句 使用 when NOT matched then 忽略 when matched then,就TMD加 else IGNORE;
此例子是DB2执行的。mysql oracle 你们直接试一试
MERGE INTO (select * from test1 ) a
USING ( select * from test2 ) b ON a.id= b.id
when NOT matched THEN INSERT (id, NAME) VALUES (b.id, b.NAME)ELSE IGNORE;
更多推荐
CNM:MERGE INTO
发布评论