您可以执行以下操作。。
创建新表并保留随机行：
第一个复制表 disk （唯一数据）到临时表 disk2 .
删除表格 disk .
重命名临时表 disk2 至 disk .

create table disk2 select * from disk group by d;

drop table disk;

rename table disk2 to disk;

注意：这里我们使用 group by 与 * 因为op不在乎保留哪一行。
创建新表并保留具有最小或最大id的行：另一种在保留具有最小或最大id的行时执行此操作的方法 min 或者 max 身份证件

/*copy data from disk to temp table disk2*/
create table disk2 select * from disk
    where id in (select min(id) from disk group by d);
/*drop table disk*/
drop table disk;
/*rename temp table to disk*/
rename table disk2 to disk;

更新：另一种方法
从现有表中删除重复项

/*first create a dups table for duplicates*/
    create table dups select * from disk
        where id not in (select min(id) from disk group by d);
    /*now delete all rows which are present in dups table*/
    delete from disk where id in (select id from dups);
    /*now delete the dups table*/
    drop table dups;

delete from disk
where id  in 
(
select id 
from task
group by id 
having count(id) >1
)

试试这个：

DELETE disk
FROM disk
INNER JOIN (
       SELECT id,
               d,
               CASE WHEN d = @prevd 
                       THEN @id:=@id+1
                    ELSE @id:=1
               END AS rankNum,
               @prevd:=d AS prd
       FROM disk, (SELECT @prevd:=NULL,@id:=NULL) t
      ) t1
ON disk.id = t1.id
WHERE rankNum >= 2;

如需演示，请点击以下链接：
https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=318e94a135853fcd15b14e4b8bbf1fdc

尝试以下操作以删除具有相同d列的重复项，并保留一行具有最低id值：

DELETE d1 
FROM  disk d1, disk d2 
WHERE d1.id > d2.id AND 
      d1.d = d2.d;

不需要创建任何临时表
我希望这对你有用

DELETE ColumnName
FROM TableName
INNER JOIN 
(
    SELECT  MAX(ID) AS ID
    FROM TableName
    GROUP BY ID
    HAVING COUNT(*) > 1
) Duplicate on Duplicate.ID = TableName.ID
WHERE TableName.ID < Duplicate.lastId;

请查看以下链接以获取更多建议
mysql删除重复记录但保留最新记录