Set MySQL group_concat length

There is no default for this configuration item in the #在MySQL配置文件 (My.ini), with the default value of 1024, the following statement modifications can be executed on the client:

#SET GLOBAL Group_concat_max_len = 1024;

#该语句执行后重启客户端即可用语句:

#show variables like "Group_concat_max_len";

#查看到已经修改成功, the statement will always work before MySQL restarts, but once MySQL restarts, the default setting value is restored.

#要彻底修改, in the MySQL configuration file (My.ini), add the

Group_concat_max_len = 1 #-1 is the maximum value or fill in the maximum length you want

#并重启mysql

#在客户端执行语句:

#show variables like "Group_concat_max_len";

The #如果为自己修改的值或4294967295 (set to-1 o'clock) is modified correctly.

Set MySQL group_concat length