How to remove duplicate records in a table?

Question

SQL

There is a table. There are duplicate entries. How can I remove them? I've been going crazy all day.
I do so

delete from `admin_eda`.`eda` 
where `eda`.`id` not in (
                         select min(`eda`.`id`) 
                         from `admin_eda`.`eda` 
                         group by `eda`.`name`
                        )

Throws
#1093 - Table 'eda' is not allowed to be specified in the FROM table list to make changes to it

Answer 1

Everything has already been done. You just need to find .

Answer 2

DELETE `t1`.*
  FROM `admin_eda`.`eda` AS `t1`
  LEFT JOIN `admin_eda`.`eda` AS `t2` ON `t2`.`name` = `t1`.`name` AND `t2`.`id` < `t1`.`id`
  WHERE `t2`.`id` IS NULL