CODEWITHSUNDEEP
mysqlconfigurationgroup-concat
devside
devside

Reputation: 2217

Unknown variable group_concat_max_len

I get an error when I try to set group_concat_max_len in the configuration file.

#my.cnf
group_concat_max_len = 2048

I get the same error in both Windows and Linux (MySQL 5)

mysql: unknown variable 'group_concat_max_len=2048'

Upvotes: 0

Views: 2958

Answers (1)

dwjv
dwjv

Reputation: 1227

This is a dynamic variable, what happens if you try to set it whilst connected:

SET GLOBAL VARIABLE group_concat_max_len=2048;

Also, what exact version are you using?

Might it be your my.cnf file, this should be under the mysqld section, e.g.:

#my.cnf
[mysqld]
group_concat_max_len=2048

Upvotes: 2

Related Questions