为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM8
【操作系统】:Windows 11
【CPU】: Inter
【问题描述】*:Mysql的ON DUPLICATE KEY语法无法适配达梦,请问mysql的语法修改为达梦是什么样子的,比如下面的SQL:
INSERT INTO wh_user_task_working_hours (id, create_by, create_time, update_by, update_time,
customer_id, task_date, wh_user_task_id, sys_user_id, working_hours,begin_time,end_time)
VALUES (#{id,jdbcType=BIGINT}, #{createBy,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP},
#{updateBy,jdbcType=VARCHAR}, #{updateTime,jdbcType=TIMESTAMP},
#{customerId,jdbcType=VARCHAR}, #{taskDate,jdbcType=DATE}, #{whUserTaskId,jdbcType=BIGINT},
#{sysUserId,jdbcType=BIGINT}, #{workingHours,jdbcType=DECIMAL},#{beginTime},#{endTime}) ON DUPLICATE KEY
UPDATE working_hours =
VALUES (working_hours), update_time = now(),
update_by =
VALUES (create_by),
begin_time = VALUES (begin_time), end_time = VALUES (end_time)
用merge into
可参考https://eco.dameng.com/community/question/f43a03d7ae585e831207ebbb0010b141