数据库删除重复数据，只保留一条有效数据

删除表中“name”字段重复的数据

DELETE FROM table1 WHERE id NOT IN (SELECT id from ( SELECT min(id) AS id FROM ceshi GROUP BY name)a)