MySQL中group_concat_max_len的最大限额是多少? [英] What is the maximum allowance for group_concat_max_len in MySQL?
问题描述
我正在使用group_concat将很多行连接成一个行.
I am using a group_concat to concatenate a lot of rows into one.
我使用以下命令将群组concat设置为10000:
I set group concat to 10000 using:
SET group_concat_max_len = 10000;
但是即使那样,我的输出单元仍然不完整,并以...结尾.
But even then, my output cells remain incomplete and end with ...
我尝试将group_concat_max_len设置为20000,即使那样也无济于事.
I tried setting group_concat_max_len = 20000 and even that didn't help.
我还尝试将group_concat_max_len设置为99999999.它仍然无法完成我的输出文本.然后我检查了其中一组concat停在Length = 230个字符处,然后给出了...
I also tried setting group_concat_max_len to 99999999. It still doesn't complete my output text. And I checked one of the group concat stops at Length = 230 characters and then gives ...
还有其他方法吗?
推荐答案
查看此链接:所有MySQL配置变量都记录在该页面上,详细信息如最小值,最大值,默认值,是否可以全局设置它们或按会话设置,是否可以在正在运行的实例上更改它们或是否需要重新启动,以及其他用法说明.
All the MySQL configuration variables are documented on that page, with details like minimum, maximum, default value, whether you can set them globally or per-session, whether you can change them on a running instance or does it require a restart, and other description of usage.
group_concat_max_len
的最大值是18446744073709551615.
The maximum value for group_concat_max_len
is 18446744073709551615.
group-concat字符串不以"..."结尾.如果尝试对太多文本进行分组,则字符串将被截断.因此,我想知道问题是否出在MySQL的设置上,而不是在单元格的显示上.
The group-concat string does not end with "..." If you try to group too much text, it just gets truncated. So I wonder if the problem is not with MySQL's settings, but with the display of your cells.
这篇关于MySQL中group_concat_max_len的最大限额是多少?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!