使用merge into ,解决无则插入 有责ignore的成效
使用merge into ,解决无则插入 有责ignore的效果
merge into zx_test T
using (select 8 ID, 'abcd' FNAME,10 AGE from sysibm.sysdummy1) A
on T.ID = A.ID
when not matched then
insert (ID,FNAME,AGE)
values(8, 'abcd',10)
引用
merge into zx_test T
using (select 8 ID, 'abcd' FNAME,10 AGE from sysibm.sysdummy1) A
on T.ID = A.ID
when not matched then
insert (ID,FNAME,AGE)
values(8, 'abcd',10)