SET GLOBAL group_concat_max_len=102400;

SET SESSION group_concat_max_len=102400;
# 去重，自定义拼接字符，默认,
select GROUP_CONCAT(distinct relationName SEPARATOR '、') ,count(1)from category_info_1688 where storeid = 'tao'  and relationName like '男装%'
select GROUP_CONCAT(distinct relationName SEPARATOR '、') ,count(1)from category_info_1688 where storeid = 'tao'  and relationName like '女装%'
select GROUP_CONCAT(distinct relationName SEPARATOR '、') ,count(1)from category_info_1688 where storeid = 'tao'  and relationName like '童装%'