526互联

ON DUPLICATE KEY UPDATE

发布时间 2023-12-19 10:22:43作者: 梅丹隆
<insert id="batchInsert" parameterType="java.util.List">
    insert into aigc_text (business_id, business_type, scene_index, text_eng, text_chn, text_prompt)
    values
    <foreach collection="records" item="r" index="index" separator=",">
        (
        #{r.businessId,jdbcType=BIGINT},
        #{r.businessType,jdbcType=INTEGER},
        #{r.sceneIndex,jdbcType=INTEGER},
        #{r.textEng,jdbcType=LONGVARCHAR},
        #{r.textChn,jdbcType=LONGVARCHAR},
        #{r.textPrompt,jdbcType=LONGVARCHAR}
        )
    </foreach>
    ON DUPLICATE KEY UPDATE
        business_id = VALUES(business_id),
        business_type = VALUES(business_type),
        scene_index = VALUES(scene_index)
</insert>

:::warning

  1. ON DUPLICATE KEY UPDATE检查主键或唯一索引字段是否冲突。
  2. update的字段值与现存的字段值相同，则不更新。
  3. 动态更新字段值用VALUES(字段名称)。
    :::