如何实现mysql数据库批量更新与添加(ON DUPLICATE KEY UPDATE)
代码
#code
INSERT INTO TABLE(ORDER_ID, TOTAL, REMAIN, CREATE_TIME, MODIFY_TIME, MODIFY_BY, DELETED ,AVAILABLE)
VALUES
<foreach collection="list" item="item" index="index" separator="," >
(#{item.orderId}, #{item.total}, #{item.remain},#{item.createTime},#{item.modifyTime},#{item.modifyBy},#{item.deleted},#{item.available})
</foreach>
ON DUPLICATE KEY UPDATE
REMAIN = values(REMAIN),
TOTAL = values(TOTAL),
MODIFY_TIME = now(),
AVAILABLE = values(AVAILABLE)
</insert>