可以使用SQL语句 "DELETE FROM table_name WHERE column_name IN (SELECT column_name FROM table_name GROUP BY column_name HAVING COUNT(*) > 1)" 来删除重复数据。
其中: table_name为表名 column_name为需要删除重复数据的列名
该语句会删除表中column_name列的重复数据。
例如: DELETE FROM student WHERE id IN (SELECT id FROM student GROUP BY id HAVING COUNT(