问我的表有唯一id，请删除重复记录

EN

Delete from table_Name A
Where exists (select 1 
From table_Name B
Where A.id = B.id
);

delete t
    from t join
         (select t.col1, t.col2, . . . ., min(t.id) as min_id
          from t
          group by t.col1, t.col2, . . .
         ) tt
         using (col1, col2, . . . )
    where t.id > tt.min_id;

DELETE FROM tbl_name WHERE condition LIMIT 1