使用分组方式删除MySQL [英] MySQL Delete with Group By

问题描述

我在MySQL 5.5中成功运行查询

  SELECT columnA 
 FROM 
 table 
 GROUP BY 
 columnA 
 HAVING 
 count（*）> 1 
  

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

任何想法？

解决方案

把它放在一个子查询中：

pre $ $ code从表中删除
其中columnA in（
select columnA
from（
）从YourTable中选择columnA
$ b $ group by columnA
have count（*）> 1
）t
）

I am running a query successfully using in MySQL 5.5

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

However, I need to run this same query using DELETE and I'm a little unsure how to delete ? i.e. the returned results should be deleted ?

Any ideas ?

解决方案

Place it in a subquery:

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

这篇关于使用分组方式删除MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！