<foreach collection="datas" item="item" separator=";"> insert into tablename( id, name ) values( #{item.id}, #{item.name} ) on conflict (id) do update set name=#{item.name} </foreach>
mybatis postgres conflict 保存或更新
最新推荐文章于 2024-05-27 10:04:50 发布
<foreach collection="datas" item="item" separator=";"> insert into tablename( id, name ) values( #{item.id}, #{item.name} ) on conflict (id) do update set name=#{item.name} </foreach>