MySql新增或修改

sql语句

INSERT INTO t_incentive_course (
    course_id,
    incentive_code,
    performance_id,
    year,
    cycle,
    dept_id,
    upms_user_id,
    reference_value,
    actual_amount,
    create_id,
    create_name,
    create_time,
    update_id,
    update_name,
    update_time,
    ext_info
)
VALUES
<foreach collection="incentiveCourseList" item="incentiveCourse" separator=",">
    (
    #{incentiveCourse.courseId},
    #{incentiveCourse.incentiveCode},
    #{incentiveCourse.performanceId},
    #{incentiveCourse.year},
    #{incentiveCourse.cycle},
    #{incentiveCourse.deptId},
    #{incentiveCourse.upmsUserId},
    #{incentiveCourse.referenceValue},
    #{incentiveCourse.actualAmount},
    #{incentiveCourse.createId},
    #{incentiveCourse.createName},
    #{incentiveCourse.createTime},
    #{incentiveCourse.updateId},
    #{incentiveCourse.updateName},
    #{incentiveCourse.updateTime},
    #{incentiveCourse.extInfo}
    )
</foreach>

on duplicate key update
    course_id=values(course_id),
    incentive_code=values(incentive_code),
    performance_id=values(performance_id),
    year=values(year),
    cycle=values(cycle),
    dept_id=values(dept_id),
    upms_user_id=values(upms_user_id),
    reference_value=values(reference_value),
    actual_amount=values(actual_amount),
    create_id=values(create_id),
    create_name=values(create_name),
    create_time=values(create_time),
    update_id=values(update_id),
    update_name=values(update_name),
    update_time=values(update_time),
    ext_info=values(ext_info)