具体业务,将一条数据加入时做校验,判断是否重复,重复删除
删选条件 plan_info_id相等,assets_info_id相等 distribute_state='-1'
DELETE m FROM `Fa_Stock_Plan_Detail` m
WHERE EXISTS (
SELECT sCode, nId FROM (
SELECT t.`plan_info_id` AS nId, t.`assets_info_id` AS sCode, COUNT(1) NUM
FROM `Fa_Stock_Plan_Detail` t WHERE 1=1 GROUP BY t.`plan_info_id`,t.`assets_info_id` HAVING NUM > 1 LIMIT 2000) tt
WHERE tt.sCode = m.`assets_info_id` AND tt.nId = m.`plan_info_id` AND m.distribute_state='-1' AND plan_info_id='843')