删除表中重复的记录
DELETE FROM 表名 WHERE id NOT IN(SELECT * FROM(SELECT id FROM
表名
GROUP BY 重复的字段名)AS b)
参考https://www.cnblogs.com/fanjp666888/p/8383906.html
