SET [GLOBAL | SESSION] group_concat_max_len = val;

Hi There,
i would like to set the val higher on my Group Concat on Mysql
I've been trying to look up how to do this, but i can't seem to set it sucessfully.

I m not sure if i am to go into the mysql ini file and reset the value if its available.
or if i can run a command to do this?
when i run the above command and enter in a value i get an error.
I would like to set the value to its Max, as currently the data being returned on my resultset it being cut off.

thank you,
PutochAsked:
Who is Participating?
 
PutochAuthor Commented:
I believe just running it on the mysql editor as
SET group_concat_max_len  = #
Works

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.