批量插入更新:mybatis-mysql
Loading...
<insert id="insertModelList" parameterType="map" useGeneratedKeys="true">
insert into model_books_item ( model_uid, model_key, model_value, model_type)
values
<foreach item="modelItem" index="index" collection="modelItemList" separator=",">
(#{modelItem.modelUid}, #{modelItem.modelKey}, #{modelItem.modelValue}, #{modelItem.modelType})
</foreach>
on duplicate key update model_value= VALUES(model_value)
</insert>