insert into td_test_robot_chatroom
(id,
name,
type
)
values
<foreach collection="list" item="list" separator=",">
(
#{list.id},
#{list.name},
#{list.type}
)
</foreach>
ON DUPLICATE KEY UPDATE
name=name,
type=type
重点是 ON DUPLICATE KEY UPDATE
:这个子句处理当插入操作遇到主键或唯一约束冲突时的情况,进行更新操作