insert into biz_assess_user(user_id,assess_id,create_time,update_time,creator_id,last_operator_id)
values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.userId},
#{item.assessId},
#{item.createTime},
#{item.updateTime},
#{item.creatorId},
#{item.lastOperatorId})
</foreach>
一个值时候也可以这样写:
<foreach collection="array" item="id" open="(" separator="," close=")">
#{id}
</foreach>