Improve company productivity with a Business Account.Sign Up

x
?
Solved

SET [GLOBAL | SESSION] group_concat_max_len = val;

Posted on 2011-02-24
1
Medium Priority
?
1,785 Views
Last Modified: 2012-05-11
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
Comment
Question by:Putoch
1 Comment
 

Accepted Solution

by:
Putoch earned 0 total points
ID: 34970172
I believe just running it on the mysql editor as
SET group_concat_max_len  = #
Works

Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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.

Join & Write a Comment

Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
Laravel is the most sought after web development framework. It comes with ample amount of features that make it easy for developers to work around it. Know about its features in detail.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

584 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question