技术教程 mysql删除重复记录只保留一条 只需一条简单sql语句 1 DELETE FROM ceshi WHERE id NOT IN (SELECT id from ( SELECT min(id) AS id FROM ceshi GROUP BY `name`,class)a)