SQL去掉重复行

delete from 表名 where id in (select max(id) from 表名 group by name having count(*)>1)

一定要设置id为唯一主键，并设置自增列