目的:根据name和class分组,将ceshi表中相同的数据删除只保留id最小的那一条。
sql语句如下:
DELETE FROM ceshi WHERE id NOT IN (SELECT id from ( SELECT min(id) AS id FROM ceshi GROUP BY `name`,class)a)
试验效果:
目的:根据name和class分组,将ceshi表中相同的数据删除只保留id最小的那一条。
sql语句如下:
DELETE FROM ceshi WHERE id NOT IN (SELECT id from ( SELECT min(id) AS id FROM ceshi GROUP BY `name`,class)a)
试验效果: