【MySQL】1260 – Row 62 was cut by GROUP_CONCAT()
xixuefeng
MySQL, MySQL-DEV
2023-09-01 14:22:53
169 次浏览
GROUP_CONCAT()
【MySQL】1260 – Row 62 was cut by GROUP_CONCAT()已关闭评论
场景:在INSERT…. SELECT GROUP_CONCAT() ….时,提示【1260 – Row 62 was cut by GROUP_CONCAT()】错误。
原因:group_concat长度限制默认是1024,当超出1024则会出现此错误。
解决办法:
1:永久解决
1 2 3 4 |
[root@DB8 ~]# vi /etc/my.cnf …… # 增加以下参数 group_concat_max_len = 1024000 |
2:临时解决
1)全局会话
1 2 3 4 |
mysql> SET GLOBAL group_concat_max_len = 10240000; Query OK, 0 rows affected mysql> |
2)当前会话
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
mysql> SHOW VARIABLES LIKE "group_concat_max_len"; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+ | group_concat_max_len | 1024 | +----------------------+-------+ 1 row in set mysql> mysql> SET SESSION group_concat_max_len=10240000; Query OK, 0 rows affected mysql> mysql> SHOW VARIABLES LIKE "group_concat_max_len"; +----------------------+----------+ | Variable_name | Value | +----------------------+----------+ | group_concat_max_len | 10240000 | +----------------------+----------+ 1 row in set mysql> |