delete from information where id in (select id from (select max(id) as id,count(*) as ccc from information GROUP BY encoding HAVING ccc>1 ) as tab)
mysql重复数据下，删除一条重复数据
原文：http://www.cnblogs.com/weiloong/p/4969214.html
