批量插入
insert into tb_enterprise_risk (id, id1,id2,...)
values
<foreach collection="list" item="item" separator=",">
((select replace(uuid(), '-', '') from dual), #{item.id1,jdbcType=VARCHAR},
#{item.id2,jdbcType=INTEGER},...)
</foreach>
批量插入
insert into tb_enterprise_risk (
id0,
id1,
id2,
id3,
id4,
...)
SELECT (SELECT REPLACE ( uuid( ), '-', '' ) id FROM DUAL),
id1,
id2,
id3,
id4,
...
FROM
table
WHERE
...
此处主键id不能更新,不知为什么
批量更新
<foreach collection="list" separator=";" item="item"> update tb_enterprise_risk_ext set state = #{item.state,jdbcType=VARCHAR}, update_time = now() where id = #{item.id} </foreach>