mysql的You can’t specify target table for update in FROM clause错误解析
mysql中不能同时对一张表进行查询和更新操作
例:delete from person where id not in (select min(id) from person group by email)这是错误的,因为对person表进行查询和删除操作
修改之后:delete from Person where Id not in (select id from (select min(Id) id from Person group by Email) p);