mysql 字段合并问题（group_concat）

mysql 字段合并问题（group_concat）

select type_id,group_concat(name) as names 
from test 
GROUP BY type_id

不同表之间字段合并

select t.type_id,group_concat(b.name) as names 
from test as t 
left join base as b
on t.row_id = b.row_id
GROUP BY type_id