达梦数据库实现一条sql判断数据是否存在，如存在则修改，不存在，则新增

 

# 达梦数据库实现一条sql判断数据是否存在，如存在则修改，不存在，则新增
MERGE
INTOX.TABLE1 T1USING (SELECT3 as id, '名字' as COLUMN_1, 0 as COLUMN_2FROMDUAL ) T2 ON(T1.id = T2.id)WHEN MATCHED THEN
UPDATE SET T1.COLUMN_1 = T2.COLUMN_1,T1.COLUMN_2 = T2.COLUMN_2WHEN NOT MATCHED THEN
INSERT(id, COLUMN_1, COLUMN_2)VALUES(T2.id, T2.COLUMN_1, T2.COLUMN_2);