group_concat_max_len settings
 

Hello,

How to increase group_concat_max_len in MySQL for a particular DB, is it possible?

If we add this entry in /etc/my.cnf file it will affect whole MySQL db right?, is there any alter way

Kind regards,
Jojan Paul

Hi,

This will affect the whole databases in MySQL db, and after editing /etc/my.cnf file the mysql service requires a restart.

eg: vi /etc/my.cnf

group_concat_max_len = 1024M

service mysql restart.

Kind regards,
Jojan paul