删除表中“name”字段重复的数据
DELETE FROM table1 WHERE id NOT IN (SELECT id from ( SELECT min(id) AS id FROM ceshi GROUP BY name)a)
删除表中“name”字段重复的数据
DELETE FROM table1 WHERE id NOT IN (SELECT id from ( SELECT min(id) AS id FROM ceshi GROUP BY name)a)
转载于:https://www.cnblogs.com/shujiying/p/10223362.html