mybatis 批量插入,报这个错误,查询资料,无法解决。仔细查看sql语句,原来语句写错了,我传的是List<Integer>型,所以,foreach 的时候,直接#{item},即可
insert into
dept_improve_rate_wash_his
(source_id,dimension_type,dimension_level,dimension_value,father_id,rate,update_time,create_time)
select
id,dimension_type,dimension_level,dimension_value,father_id,rate,current_timestamp,current_timestamp
where id in
<foreach collection="list" item="item" index="index"
separator=",">
(
#{item}
)
</foreach>