MySQL 使用 Group By 删除

Question

我正在 MySQL 5.5 中成功运行查询

SELECT columnA
FROM
  table
GROUP BY
  columnA
HAVING
  count(*) > 1

但是，我需要使用 DELETE 运行相同的查询，并且我有点不确定如何删除？即返回的结果应该被删除？

有什么想法吗？

Answer 1

将其放在子查询中：

delete from table 
where columnA in (
  select columnA
  from (
      select columnA
      from YourTable
      group by columnA
      having count(*) > 1
      ) t  
)

Answer 2

delete from YourTable
where
  YourTable.columnA 
  in 
  (select columnA
  from
    YourTable
  group by
    column A
  having
    count(*) > 1)