between
The only limit is the size of the VARCHAR field
-Original Message-
From: Andrey Dmitriev [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 08, 2008 12:34 AM
To: mysql@lists.mysql.com
Subject: group_concat display limit
All,
We are using group_concat but there seems to be some
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
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
