DELETE FROM 表 WHERE id NOT IN ( SELECT id FROM ( SELECT min(b.id) AS id FROM 表 b GROUP BY b.重复字段 ) b )
Mysql 删除重复数据只保留id最小的
原文：http://www.cnblogs.com/blog5277/p/7605797.html
