如果有更新没有新增 ON DUPLICATE KEY UPDATE

单个更新

<insert id="updateUser" useGeneratedKeys="true"
            keyProperty="id">
        INSERT INTO lock_user_name
        <trim prefix="(" suffix=")" suffixOverrides=",">
            user_name,
            phone,
            <if test="id != null  ">id,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            #{userName},
            #{phone},
            <if test="id != null  ">#{id},</if>
        </trim>
        ON DUPLICATE KEY UPDATE phone=#{phone}, user_name=#{userName}
    </insert>

多个更新

    <insert id="DevInsert" parameterType="List">
        insert into company_device_attribute (device_code,`key`,create_time,`value`) values
        <foreach collection="list" item="LierdaluxAtt" index="index" separator=",">
            (#{LierdaluxAtt.deviceCode}, #{LierdaluxAtt.key}, #{LierdaluxAtt.createTime},
            #{LierdaluxAtt.value} )
        </foreach>
        ON DUPLICATE KEY UPDATE
        device_code=values (device_code),
        `key`=values (`key`),
        create_time=values(create_time),
        `value`=values (`value`)
    </insert>