我目前有一些带回标签的 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 选择不同的行到逗号分隔的列表列中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!