The variable 'group_concat_max_len' has a default of 1024 (1K)
Add this to you're my.cnf to make it 8K
[mysqld]
group_concat_max_len=8192
--
Another way without altering 'group_concat_max_len' is
To manually concatenate the string pieces with blanks in between
The only limit is
learnt.
On Jan 8, 2008 2:11 PM, Werner Puschitz <[EMAIL PROTECTED]> wrote:
> Andrey Dmitriev wrote:
> > All,
> >
> > We are using group_concat but there seems to be some sort of display
> > limit.
> > Is there are a way to unset or increase it?
> >
> > Thanks,
> > Andrey
> >
>
> You can change th
Andrey Dmitriev wrote:
> All,
>
> We are using group_concat but there seems to be some sort of display
> limit.
> Is there are a way to unset or increase it?
>
> Thanks,
> Andrey
>
You can change the maximum length by setting the group_concat_max_len
system variable to a higher value which is
You should change your sql to related sub query.
On Jan 8, 2008 1:34 PM, Andrey Dmitriev <[EMAIL PROTECTED]> wrote:
> All,
>
> We are using group_concat but there seems to be some sort of display
> limit.
> Is there are a way to unset or increase it?
>
> Thanks,
> Andrey
>
>
--
I'm a mysql DBA
