You can‘t specify target table ‘Person‘ for update in FROM clause

背景：

原因：简言之，就是mysql不支持在一个表同时实现查找和删除。

解决方案：中间表，查到之后 再select一次。

//错误代码

delete from Person 
where id not in 
(
    select MIN(Id) as id
    from Person 
    group by Email
)


//正确代码


delete from Person 
where id not in 
(
    select t.id from   
    (
        select MIN(Id) as id
        from Person 
        group by Email
    ) t
)