insert主键冲突控制

来源:互联网 发布:linux exp continue 编辑:程序博客网 时间:2024/05/16 18:44
<insert id="saveQuotaAudiData" parameterType="com.dyt.apv.management.dto.QuotaAudiProcessDTO">
    INSERT INTO `apv_quota_audi_process` (`oid`, `apv_result`,`business_id`, `task_id`,task_name,`approval_quota`, `is_temporary_guard`,handle_user, `opinion`, `created_by`,updated_by) 
    VALUES (#{oid},#{apvResult}, #{businessId}, #{taskId}, #{taskName},#{approvalQuota}, #{isTemporaryGuard},#{handleUser}, #{opinion}, #{createdBy},#{updatedBy})
ON DUPLICATE KEY 
UPDATE apv_result = values(apv_result),
approval_quota=values(approval_quota),
is_temporary_guard = values(is_temporary_guard),
handle_user = values(handle_user),
opinion = values(opinion),
updated_by = values(updated_by)
</insert>