mysql 删除相同的记录

不能直接用delete from test where id not in (select id from test);

、、要用

drop TABLE if EXISTS temp;
CREATE TABLE temp as select min(id) as id from test GROUP BY name;
delete from test where id not in (select id from temp);