mysql> show variables like "group_concat%";
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| group_concat_max_len | 1024 |
+--------------------------+------------+
1.修改配置文件(直接通过sql语句修改)
SET GLOBAL group_concat_max_len = 102400;
退出重新登录可查看修改后的值