出现情况
有时我们在用 group_concat 进行截取字符串时 当超过最大截取时就会丢失字符串,这是我们不想看到的,
下面给出处理方案;
查看长度限制命令:
show variables like 'group_concat_max_len'
修改长度限制命令:
SET GLOBAL group_concat_max_len = 102400;
SET SESSION group_concat_max_len = 102400;
执行过程
mysql> show variables like 'group_concat_max_len';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| group_concat_max_len | 1024 |
+----------------------+-------+
1 row in set
mysql> SET GLOBAL group_concat_max_len = 102400;
SET SESSION group_concat_max_len = 102400;
Query OK, 0 rows affected
Query OK, 0 rows affected
mysql> show variables like 'group_concat_max_len';
+----------------------+--------+
| Variable_name | Value |
+----------------------+--------+
| group_concat_max_len | 102400 |
+----------------------+--------+
1 row in set
mysql>