当MySQL表中存在有大量重复数据,却又只要其中一条数据时,可以使用以下sql来快速删除重复数据,节省时间,sql如下:
DELETE FROM `表名` WHERE id NOT IN (SELECT id from ( SELECT min(id) AS id FROM `表名` GROUP BY `分组字段`) temp);
当MySQL表中存在有大量重复数据,却又只要其中一条数据时,可以使用以下sql来快速删除重复数据,节省时间,sql如下:
DELETE FROM `表名` WHERE id NOT IN (SELECT id from ( SELECT min(id) AS id FROM `表名` GROUP BY `分组字段`) temp);