mysql更新重复数据状态(重复数据入库时间靠前的) 

UPDATE spider_company_business_risk.t_government_permission SET IsValid = 0 WHERE Id IN 
(SELECT min(Id) FROM spider_company_business_risk.t_government_permission GROUP BY LicenseNo HAVING COUNT(LicenseNo) > 1)

 

posted @ 2021-08-17 10:43  Eliphaz  阅读(179)  评论(0)  编辑  收藏  举报