<insert id="deptIdMatch">
INSERT INTO`sys_dept_match`(`bpm_dept_id`, `cloud_dept_id`) VALUES
<foreach item="list" index="list" collection="list" separator=",">
(#{list.bpmDeptId},#{list.cloudDeptId})
</foreach>
ON DUPLICATE KEY UPDATE
bpm_dept_id = VALUES(bpm_dept_id)
</insert>
MySQL+Mybatis批量插入时对已存在的记录进行更新
最新推荐文章于 2023-08-01 14:43:47 发布