saveOrupdate（达梦）

 

MERGE INTO t_person T1
USING (
  SELECT
  1 id,
  'test' mc,
  1 sex,
  25 age,
  FROM dual
) T2 ON (T1.id = T2.id)
WHEN NOT MATCHED THEN INSERT(id, mc, sex,
age) VALUES
(T2.id, T2.mc, T2.sex, T2.age)
WHEN MATCHED THEN UPDATE
SET T1.mc = T2.mc,T1.sex = T2.sex,T1.age = T2.age

 set后不能有主键

using（）里是要更新的值，后边是对应的字段

insert语句的values正常写 

不知道适不适用其它数据库