Removing Duplicate SQL Rows

Question

MySQL

I want to remove duplicate lines.
Only the id field (autoincrement) differs.
I tried to make several different "NOT IN" and "NOT EXIST" constructs, but they all give a syntax error. Apparently I'm a shitty requester. What queries do you use to remove duplicates?

Answer 1

DELETE `t1`.* FROM `table` AS `t1`
    LEFT JOIN (SELECT `id` FROM `table` GROUP BY `field1`, `field2`, ...) AS `t2` 
        ON `t1`.`id` = `t2`.`id`
    WHERE `t2`.`id` IS NULL

Answer 2

DELETE FROM tbl WHERE id NOT IN(
  SELECT MAX(id) FROM tbl GROUP BY <поле 1>[,<поле 2>]
)

Answer 3

delete from table where id IN (
select id from (
select field, Count(field) as Count
from table
group by field
having count(field)>1) )