玖叶教程网

mysql函数GROUP_CONCAT()行转列

例如，表aaaa

id    	name
1		a1
1		a11
1		a111
1		a111
2		a22
2		a222
3		a33

SELECT id
	,GROUP_CONCAT(name) as name_1
	,GROUP_CONCAT(name separator '_') as name_11
	-- 降序，不去重，以_分割
	,GROUP_CONCAT(name ORDER BY name desc separator '_') as name_111
 -- 降序，去重，（id为1时，a111有两个值，）
  ,GROUP_CONCAT(DISTINCT name ORDER BY name desc) as name_2
	,GROUP_CONCAT(DISTINCT name ORDER BY name desc separator '_') as name_3
from aaaa
group by id

查询结果

2021-11-13