Delete redundant duplicate records in MySQL

Check for duplicate records

--Check for duplicate code1Select Count(Identity) Num,Identity  fromEvent_logwhereCode='Code1' Group  by Identity  having Count(Identity)> 1Order  byNumdesc

Delete duplicate records

DELETE  fromEvent_logWHERE' Code '='Code1'  and Identity inch (    SELECT Identity  from (        SELECT Identity  fromEvent_logWHERECode='Code1' GROUP  by Identity  having Count(Identity)> 1) a) andId not inch (    SELECTKeepid from (        SELECT min(ID) keepid fromEvent_logWHERECode='Code1' GROUP  by Identity  having Count(Identity)> 1) b)

Where A and B two intermediate tables function to avoid the occurrence of you can ' t specify target table ' xxxxx ' for the update in the FROM clause error

Delete redundant duplicate records in MySQL