mysql 选择不同的行到逗号分隔的列表列中 [英] mysql select distinct rows into a comma delimited list column

问题描述

我目前有一些带回标签的 sql.他们应该有不同的 id，但他们没有......所以我当前的数据是这样的:

I currently have some sql that brings back tags. they should have distinct ids, but they don't.... so my current data is like:

Microsoft | GGG | 1 | 167
Microsoft | GGG | 1 | 2
Microsoft | GGG | 1 | 1

我想要做的是只返回一行，最后一列连接成一个分隔列表，如:

What i would like to do is have only one row come back with the final column concatenated into a delimited list like:

Microsoft | GGG | 1 | 167, 2, 1

我为此使用了 mySQL 5.

I am using mySQL 5 for this.

推荐答案

使用 GROUP_CONCAT() 为此，GROUP BY 覆盖其他三列:

Use GROUP_CONCAT() for this, with a GROUP BY covering the other three columns:

SELECT 
  name,   -- Microsoft
  other,  -- GGG
  other2, -- 1
  GROUP_CONCAT(id) AS ids
FROM tbl
GROUP BY name, other, other2

这篇关于mysql 选择不同的行到逗号分隔的列表列中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！