INSERT
into t_brokerage
(Fuid
,Fsku_id
,Fsku_brokerage)
values
<foreach collection ="brokerageList" item="brokerage" separator =",">
(#{brokerage.fuid}
,#{brokerage.fskuId}
,#{brokerage.fskuBrokerage})
</foreach >
ON DUPLICATE KEY UPDATE
Fsku_brokerage = values(Fsku_brokerage);
当需求需要批量导入的,且需要保证如果主键或唯一索引键已存在,则覆盖需求,可以用
ON DUPLICATE KEY UPDATE 语法
示例如上,博主的Fuid,Fsku_id是联合的唯一索引键,所以覆盖的字段就只写Fsku_brokerage(可以覆盖多个字段)