mysql - 将 SELECT 语句更改为 DELETE

Question

这个问题已经有答案了:

Remove duplicates using only a MySQL query? (8 个回答)

deleting duplicate records (4 个回答)

已关闭 9 年前。

我的表中有很多重复的行。我有一个 SELECT 提供了我想要删除的数据，但我该如何执行此操作？无论我尝试什么，我都会收到错误。

SELECT *
  FROM tablename t
 WHERE NOT EXISTS (         
              SELECT 1
                FROM tablename t2
               WHERE t2.column = t.column
              HAVING COUNT(*) = 1
                     )

Answer 1

只需将“SELECT *”更改为“DELETE”

DELETE 
FROM tablename t
WHERE NOT EXISTS (         
              SELECT 1
              FROM tablename t2
              WHERE t2.column = t.column
              HAVING COUNT(*) = 1
              )