查询某一列重复数据
SELECT * FROM my_effect t WHERE eff_name IN (SELECT eff_name FROM my_effect GROUP BY eff_name HAVING COUNT(eff_name)>1 ) ORDER BY t.eff_name;
删除某一列重复数据
delete from my_effect where id not in (select a.min_id from (select min(id) as min_id from my_effect group by eff_name) as a)