摘要:
下文讲述MySQL字段群组的示例简介说明,如下所示:
例:
drop table if exists T_maomao;
create table T_maomao
select 'maomao' main, 'mysql' sub union all
select 'maomao', 'mysql' union all
select 'maomao', '' union all
select 'maomao', null union all
select 'maomao', 'sqlserver' union all
select 'maomaoB', 'sqlserver' union all
select 'maomaoB', 'DB2' union all
select 'maomaoC', 'oracle' union all
select 'maomaoC', 'redis' ;
select * from T_maomao;
select main,group_concat(sub) as sub
from T_maomao group by main;
//群组后,直接将sub字段进行拼接
select main,group_concat(distinct sub) as sub
from T_maomao group by main;
//群组后,对sub 去重,但未去null字符串
select main,
group_concat(distinct nullif(sub,'')) as sub
from T_maomao group by main;
//群组后,对sub 去重,并对null字符串进行处理