mysql去重 假设一张表,全部字段,A,B,C,D 然后,我要去重,去掉A,B,C...答:假设D列为ID列是Pramary Key,SQL如下:select * from table_name where D in(select mid from (select min(D) as mid from table_name group by A,B,C having count(*)>1) test );查询后进行观察,无误后进行delete操作:delete from table_name where D in(select mid from (...