mysql not exists 太慢_not exists优化 mysql数据存在不插入

最新推荐文章于 2023-03-03 22:20:02 发布

数据与算法DEV

最新推荐文章于 2023-03-03 22:20:02 发布

阅读量672

点赞数

文章标签： mysql not exists 太慢

本文链接：https://blog.csdn.net/weixin_28916817/article/details/113593065

版权

*FROM Hrm_HrmData

WHERE (isDimission= 79 AND onDutyTime < date_add(‘2020-0-01‘, interval 1MONTH))

OR (isDimission= 80 AND outDutyTime >= date_add(‘2020-01-01‘, interval 1MONTH))

) h

WHERE NOT EXISTS(

SELECT * FROM DataAnalysis_HrmDataHistory WHERE DataAnalysis_HrmDataHistory.employeeCode = h.employeeCode

)

INSERT INTO DataAnalysis_HrmDataHistory

(estate,lockstate,delestate,creator,created,modifier,modified,name,employeeCode,sex,department_id,place_id,onDutyTime,outDutyTime,isDimission,birthday)

SELECT estate,lockstate,delestate,creator,created,modifier,modified,chineseName,employeeCode,sex,department_id,subCompany,onDutyTime,outDutyTime,isDimission,birthday

FROM

(

SELECT*FROM Hrm_HrmData

WHERE (isDimission= 79 AND onDutyTime < date_add(‘2020-01-01‘, interval 1MONTH))

OR (isDimission= 80 AND outDutyTime >= date_add(‘2020-01-01‘, interval 1MONTH))

) h

WHERE h.employeeCodenot in(

SELECT employeeCode FROM DataAnalysis_HrmDataHistory

)

not exists优化 mysql数据存在不插入

标签：modifier sts rom com mon 代码 art stat div

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉