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屋！