mysql - 我在编写删除数据库中重复数据的 mysql 查询时出错

Question

我试过下面的代码

 DELETE FROM `f` FROM 'exam' AS 'f' INNER JOIN 'exam' AS 'g' on
                  f.question=g.question any f.id<g.id;

在数据库中查找重复项所以请进行必要的更改，以便我可以消除错误

Answer 1

将any更改为and并将.*添加到f:

DELETE f.* FROM `exam` f
INNER JOIN `exam` AS g 
on f.question=g.question
and f.id < g.id;