SET [GLOBAL | SESSION] group_concat_max_len = val;
Posted on 2011-02-24
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.