连接一个列的值 一般和分组一起使用
– 默认逗号连接
select t.type,group_concat(t.name) “result” from exe t group by t.type;
- separator 设置以;隔开
select t.type,group_concat(t.name separator ‘;’) “result” from exe t group by t.type;
– 排序连接
select t.type,group_concat(t.name order by t.other desc) “result” from exe t group by t.type;