为何在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”
[code="sql"]delete from test_table where id not in (select min(id) from test_table group by name) as t[/code]
这个问题就是你上面的语法mysql不支持！用用别名了试试！