您的位置首页百科问答

merge

merge

的有关信息介绍如下:

merge

merge into table a

using

() b on a=b

when matched then

update set k=(case when a=1 and b=2 then 1 else k end),

m=(case when a=2 and b=1 then 2 else m end) where...;

when not matched then