Question

为何问题补充中的sql语句中delete后面要跟表名呢？基本的mysql语句中delete后面直接from表名不就可以了吗？

delete users as a from users as a,( select min(id) , name from users group by name having count(name)
> 1) as b where a.name = b.name and a.id <>b.id;

Answer 1

95%肯定你是access吧，access独有的现象，原因在于这个表后面的字查询要用到，所以要那样写

Answer 2

delete users as a,( select min(id) , name from users group by name having count(name)
> 1) as b where a.name = b.name and a.id <>b.id