Merge into 实现匹配到就更新,匹配不到就插入
merge into 目标表 a
using 源表 b
on a.id=b.id
when matched then
update set a.要修改的字段=b.要匹配的字段,a.要修改的字段='常量'
when not
Merge into 实现匹配到就更新,匹配不到就插入
merge into 目标表 a
using 源表 b
on a.id=b.id
when matched then
update set a.要修改的字段=b.要匹配的字段,a.要修改的字段='常量'
when not