SQL报错：You can’t specify target table ‘person’ for update in FROM clause的解决方法

You can’t specify target table ‘person’ for update in FROM claus

不能在FROM子句中指定要更新的目标表'person'

报错原因：在MySQL中不能在同一条SQL中查询出一张表的某些值，再直接用这些值更新这张表。

解决方案：将查询出的结果用SELECT再查询一次，得到一张额外的临时表，再用临时表的值做更新。

解决前：

delete from person where id in (select b.id as id_id from person as a,person as b where a.email=b.email and a.id<b.id);

解决后：

delete from person where id in (select t.id_id from (select b.id as id_id from person as a,person as b where a.email=b.email and a.id<b.id) as t);