• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1758
  • Last Modified:

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,
0
Putoch
Asked:
Putoch
1 Solution
 
PutochAuthor Commented:
I believe just running it on the mysql editor as
SET group_concat_max_len  = #
Works

Thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now