Java--批量插入更新在一条sql里解决-mybatis-mysql-联合主键(建立唯一索引)

批量插入更新: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>