LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   group_concat_max_len settings (https://www.linuxquestions.org/questions/linux-newbie-8/group_concat_max_len-settings-4175502914/)

jojanmpaul 04-25-2014 12:15 AM

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

jojanmpaul 04-27-2014 10:49 PM

Quote:

Originally Posted by jojanmpaul (Post 5158805)
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


All times are GMT -5. The time now is 12:17 PM.