merge into的形式:
MERGE INTO [target-table] A USING [source-table sql] B ON([conditional expression] and [...]...)
WHEN MATCHED THEN
[UPDATE sql]
WHEN NOT MATCHED THEN
[INSERT sql]
作用:判断B表和A表是否满足ON中条件,如果满足则用B表去更新A表,如果不满足,则将B表数据插入A表但是有很多可选项,如下:
merge into a using(select *from b)
on (a.id=b.id)
when matched then
update
set
a.id=b.id,
a.name=b.name
when not matched then
insert into
(
id,
name
)
values
(
'1',
'zhang'
)
sql