MySQL中group_concat函数
完整的语法如下:
group_concat([DISTINCT] 要连接的字段 [Order BY ASC/DESC 排序字段] [Separator ‘分隔符’])
基本查询
11 | 6 rows in set (0.00 sec) |
|
以id分组,把name字段的值打印在一行,逗号分隔(默认)
1 | select id,group_concat( name ) from student group by id; |
|
2 | | id | group_concat(name) | |
8 | 3 rows in set (0.00 sec) |
|
以id分组,把name字段的值打印在一行,分号分隔
1 | select id,group_concat( name separator ’;’) from aa group by id; |
|
2 | | id | group_concat(name separator ‘;’) | |
8 | 3 rows in set (0.00 sec) |
|
以id分组,把去冗余的name字段的值打印在一行,逗号分隔
1 | select id,group_concat( distinct name ) from aa group by id; |
|
2 | | id | group_concat(distinct name) | |
8 | 3 rows in set (0.00 sec) |
|
以id分组,把name字段的值打印在一行,逗号分隔,以name排倒序
1 | select id,group_concat( name order by name desc ) from aa group by id; |
|
2 | | id | group_concat(name order by name desc) | |
8 | 3 rows in set (0.00 sec) |
|
转载自 https://blog.csdn.net/HibonLi/article/details/72897486