I don't think so unfortunately. He says in his first mail:
> I'm using an excel library that accepts a SELECT as input and generates an
> XLS file with the records as output.
So, probably csv is not going to help him, which is a shame :)
Walter
OlinData: Professional services for MySQL
Support
I think what you are looking for is something like this:
-
SELECT
CONCAT(A.FIELD1,',',GROUP_CONCAT(B.FIELD2))
FROM
TABLE1 A LEFT JOIN TABLE2 B
ON A.ID=B.ID_TABLE1
-
Hi,
I did consider a procedure but the problem is that the client is still using
MySQL 4.x, which afaik doesn't support stored procedures. An upgrade is not
something they can do at this point, as they're using s shared host so the
server isn't really under their control.
I think what you're r
>-Original Message-
>From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On
>Behalf Of Vikram Vaswani
>Sent: Monday, January 26, 2009 11:29 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Help with formatting of 1:n relationship
>
>
Hi,
On Mon, Jan 26, 2009 at 11:29 AM, Vikram Vaswani wrote:
> Hi Jerry
>
> Thanks for your input on this!
>
>
>>> I'm using an excel library that accepts a SELECT as input and generates
>>> an XLS file with the records as output. I'd like to use this where
>>> possible. However I don't know if it
Hi Jerry
Thanks for your input on this!
I'm using an excel library that accepts a SELECT as input and generates
an XLS file with the records as output. I'd like to use this where
possible. However I don't know if it's possible to write a SELECT that
compresses a 1:n relationship into a single
>-Original Message-
>From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On
>Behalf Of Vikram Vaswani
>Sent: Monday, January 26, 2009 7:02 AM
>To: mysql@lists.mysql.com
>Subject: Help with formatting of 1:n relationship
>
>Hello all
>
>I have a database with a 1:n relationshi
