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

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)) #date_add('2020-01-01', interval 1 MONTH) = '2020-02-01' 往后推一个月

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

)