MySQL中group_concat函数
完整的语法如下:
group_concat([DISTINCT] 合并字段 [Order BY 排序字段 ASC/DESC] [Separator '分隔符'])
原始表
SELECT * FROM test.student;
以name分组,把dept字段的值打印在一行,逗号分隔(默认)
select name, group_concat(dept) from test.student group by name;
以name分组,把dept字段的值打印在一行,“/”分隔
select name, group_concat(dept separator '/') from test.student group by name;
以name分组,把dept字段的值打印在一行,去冗余
select name, group_concat(distinct dept separator '/') from test.student group by name;
以name分组,把id字段的值打印在一行,以id倒序
select name, group_concat(id order by id desc) from test.student group by name;