CODEWITHSUNDEEP
mysql
Gourav Rathore
Gourav Rathore

Reputation: 11

How to set up group_concat_max_length permanently in Mysql?

How to set up group concat max length permanently in Mysql?

While setting group concat max length:

SET group_concat_max_len=102400

At the time it is set, but after restarting the server, it shows its default value 1024 again.

Upvotes: 0

Views: 3976

Answers (2)

Algoleigol
Algoleigol

Reputation: 201

Edit my.cnf file and add group_concat_max_len=102400 under [mysqld] section. Then restart mysql service and that's all.

Upvotes: 2

Patryk Rogosch
Patryk Rogosch

Reputation: 306

You can pass it to MySQL deamon via param:

--group_concat_max_len=xxx

Upvotes: 1

Related Questions