<insert id="insertUser" parameterType="com.haohao.model.User">
merge into user a using(
select #{id} as id
) b
on (a.id=b.id)
when matched then
update set
userName=#{userName},
sex=#{sex},
age=#{age}
when not matched then
insert
(id,userName,sex,age)
values
(#{id},#{userName},#{sex},#{age})
</insert>
Springboot+Mybatis实现merge into数据的单条插入更新(有则插入无则更新)
最新推荐文章于 2023-02-03 11:48:15 发布