mysql 重复数据删除问题

Question

为何在mysql5.018中使用delete from test_table where id not in (select min(id) from test_table group by name)进行重复数据删除会报如下提示“you can't specify target table 'test_table' for update in from clause”

Answer 1

[code="sql"]delete from test_table where id not in (select min(id) from test_table group by name) as t[/code]