On 2015/05/07 19:42, Paul Halliday wrote:
Should have showed the whole thing. Take a look here (click image to see
full output):
http://www.pintumbler.org/tmp
I don't see why this worries you. Joining often increases variation.
Indeed, if in some case an inner join never did, maybe the joined
gt;> If I do something like (pseudo):
>>
>> SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types FROM tbl1
>>
>> returns something like:
>>
>> n c_types
>> 1 t9
>>
>> when I add a left join though:
>>
>> SELECT count(val) AS n
First, have you tried GROUP_CONCAT(DISTINCT types) ?
Second I see my counts rise just as my group_concat() terms when I do
something similar to what you're talking about. Also, here:
val c_types d_types
3t9,t9,t9 a2,a3,a9
Your column headers don't seem to match
Hi Paul,
On 5/7/2015 10:17 AM, Paul Halliday wrote:
Fighting a bit with this one...
If I do something like (pseudo):
SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types FROM tbl1
returns something like:
n c_types
1 t9
when I add a left join though:
SELECT count(val) AS n, GROUP_CONCAT
Fighting a bit with this one...
If I do something like (pseudo):
SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types FROM tbl1
returns something like:
n c_types
1 t9
when I add a left join though:
SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types,
GROUP_CONCAT(two.types) AS d_types
;>>> 2012/03/19 12:06 -0400, Steven Staples >>>>
SELECT `user_id`, GROUP_CONCAT(DISTINCT `login_ip`) AS 'login_ips',
COUNT(`id`) AS 'connections'
FROM `mysql_test`
WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19
23:5
> -Original Message-
> From: Mihail Manolov [mailto:mihail.mano...@liquidation.com]
> Sent: March 19, 2012 12:44 PM
> To: Steven Staples
> Cc:
> Subject: Re: Group_Concat help...
>
> Try this
>
> SELECT `user_id`, `login_ip`,
> COUNT(`id`) AS 'co
Mar 19, 2012, at 12:06 PM, Steven Staples wrote:
> SELECT `user_id`, GROUP_CONCAT(DISTINCT `login_ip`) AS 'login_ips',
> COUNT(`id`) AS 'connections'
> FROM `mysql_test`
> WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19
>
Hello!
I am trying to do something, but I can't seem to figure out how...
My query is as follows:
SELECT `user_id`, GROUP_CONCAT(DISTINCT `login_ip`) AS 'login_ips',
COUNT(`id`) AS 'connections'
FROM `mysql_test`
WHERE `login_datetime` BETWEEN '2012-03-19 00:0
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?
> >
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 varia
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,
>
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
On 6/21/06, Kim Christensen <[EMAIL PROTECTED]> wrote:
Hey list;
I'm having trouble with the GROUP_CONCAT() function, which (according
to the docs) is supposed to give me a column with the VARCHAR type,
unless group_concat_max_len is >512. Instead it BLOBs me!
Hmm, I just reali
On 6/21/06, Kim Christensen <[EMAIL PROTECTED]> wrote:
Hey list;
I'm having trouble with the GROUP_CONCAT() function, which (according
to the docs) is supposed to give me a column with the VARCHAR type,
unless group_concat_max_len is >512. Instead it BLOBs me!
Hmm, I just reali
Hey list;
I'm having trouble with the GROUP_CONCAT() function, which (according
to the docs) is supposed to give me a column with the VARCHAR type,
unless group_concat_max_len is >512. Instead it BLOBs me!
Now, I haven't set any value for the group_concat_max_len, so it
shouldn&#
Hey list;
I'm having trouble with the GROUP_CONCAT() function, which (according
to the docs) is supposed to give me a column with the VARCHAR type,
unless group_concat_max_len is >512. Instead it BLOBs me!
Now, I haven't set any value for the group_concat_max_len, so it
shouldn&#
SELECT * ,
GROUP_CONCAT(DISTINCT language.language SEPARATOR ', ') AS Sprachen
FROM item_all_language
LEFT JOIN item ON itemitem_identity = item.item_identity
LEFT JOIN language ON languagelanguage_identity = language.language_identity
GROUP BY item.titel;
SELECT * , GROUP_CON
On 17/11/2005, Peter Brodersen wrote:
> I would like to select top three from different parts in the same
> table, e.g. for the following data set:
USE test;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
fid INT NOT NULL,
d INT NOT NULL
);
INSERT INTO foo VALUES
(1, 10), (1, 20),
I tried using a subquery using LIMIT inside, but I just got the
> following result:
> ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/A=
> LL/ANY/SOME subquery'
> It seems like this was a possibility in very early versions of MySQL 4.1.
>
answer.
I tried using a subquery using LIMIT inside, but I just got the
following result:
ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT &
IN/ALL/ANY/SOME subquery'
It seems like this was a possibility in very early versions of MySQL 4.1.
I tried with GRO
I meant 600k not 6meg. Sorry
>>> "Ed Reed" <[EMAIL PROTECTED]> 9/30/05 9:46:32 AM >>>
That's not true.
Group_Concat can already return more than 6meg. It's set by
group_concat_max_len variable. The fact is that I've been told there are
secu
That's not true.
Group_Concat can already return more than 6meg. It's set by
group_concat_max_len variable. The fact is that I've been told there are
security issues corrected in the 4.1.14a update and I can't apply them because
it will break my already existing ap
In the last episode (Sep 27), Ed Reed said:
> Will someone please respond to this?
>
> >>> "Ed Reed" <[EMAIL PROTECTED]> 9/22/05 1:30 PM >>>
> Bump!
>
> >>> "Ed Reed" < [EMAIL PROTECTED] > 9/21/05 2:09:58 PM >>
Will someone please respond to this?
- Ed
>>> "Ed Reed" <[EMAIL PROTECTED]> 9/22/05 1:30 PM >>>
Bump!
>>> "Ed Reed" < [EMAIL PROTECTED] > 9/21/05 2:09:58 PM >>>
I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat re
Bump!
>>> "Ed Reed" <[EMAIL PROTECTED]> 9/21/05 2:09:58 PM >>>
I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns garbage. In
the previous version Group_Concat returned a text string and after the upgrade
they are returning a blob.
I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns garbage. In
the previous version Group_Concat returned a text string and after the upgrade
they are returning a blob.
Hello, I have a strong need/desire to use group_concat but I don't/can't run
4.1 right now. There is MyGroupConcat
http://www.codeproject.com/useritems/MyGroupConcat.asp
And I have no problem creating a .so on FreeBSD but I have a server running
OSX and I'm not familiar with
Hi all!
I'm wondering - are there any alternative to the function
group_concat() for mysql servers prior to 4.1?
The reason for asking is that I'm building a library database, where
each book can have n numbers of authors, where n >= 0. In listings I
want to get all the authors o
I finally installed 4.1 alpha so I could test the group_concat
function but need some help... could anyone give me a clue how
I can order the results of group_concat() according to the lft
field ? (just adding it per se wipes out the results)
I have tried many many variations and have not hit
31 matches
Mail list logo
