insert into t_user_rank
(userID,flower,classID,rank)
values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.userID},#{item.flower},#{item.classID},#{item.rank})
</foreach>
on duplicate key update
flower = values(flower),rank = values(rank)
mybatis+mysql批量插入存在即更新
最新推荐文章于 2024-06-18 17:23:51 发布