Mybatis实现插入并更新，有唯一索引和没有唯一索引的情况

没有唯一索引

<insert id="saveOrUpdate2" >
  <select count(*) as count from user where id = #{id} for update</select>
  <if test="count > 0">
    update user set age = #{age}, name = #{name} where id = #{id}
  </if>
  <if test="count == 0">
    insert into user (age, name) values (#{age}, #{name})
  </if>
</insert>

有唯一索引

唯一索引为name

<insert id="insertOrUpdateUser" parameterType="User">
  INSERT INTO user (name, age, email)
  VALUES (#{name}, #{age}, #{email})
  ON DUPLICATE KEY UPDATE
  age = VALUES(age),
  email = VALUES(email);
</insert>