如何从MySQL表中删除重复的行

DELETe DupRows.*FROM MyTable AS DupRows   INNER JOIN (      SELECt MIN(ID) AS minId, col1, col2      FROM MyTable      GROUP BY col1, col2      HAVINg COUNT(*) > 1   ) AS SaveRows ON SaveRows.col1 = DupRows.col1 AND SaveRows.col2 = DupRows.col2      AND SaveRows.minId <> DupRows.ID;

当然，您必须在所有三个位置将col1，col2扩展到所有列。

编辑：我只是从保留的脚本中重新进行了测试，然后重新测试，它在MySQL中执行。