I'm glad you mentioned your book. I forgot that it was on my list of best books to buy next time I'm at the bookstore. And it's also on my list of what type of spagetti sauce to pick up at the grocery store. . . . .
>>> "Spike " <mysqldba-ezmlmshield-x76351952.[Email address protected] 10/29/2007 8:29:27 AM >>>
We were hoping for an example or a suggestion ...not a book advert.
Anthony Molinaro wrote:
> I show how to do it in oracle, mysql, db2, postgresql and sql server in my book:
>
> http://www.amazon.com/Cookbook-Cookbooks-OReilly-Anthony-Molinaro/dp/0596009763/ref=pd_bbs_sr_2/103-2289700-5418224?ie=UTF8&s=books&qid=1193668116&sr=1-2
>
> There are many ways to do it, I highlight a few in my book (I also show an alternative for Oralce online using the MODEL clause in 10g
> On the errata page of my book on the oreilly site).
>
> Of all the db's though, I'd say that mysql's group_concat is the best builtin for this sort of problem.
>
> Regards,
> Anthony
>
> -----Original Message-----
> From: Αναστάσιος Παπαδόπουλος [mailto:mysqldba-ezmlmshield-x19036192.[Email address protected]
> Sent: Monday, October 29, 2007 5:13 AM
> To: LazyDBA Discussion
> Subject: RE: Multiple Rows
>
> Then he posted to the wrong list :P
>
> It would be interesting though if anyone knows how to do this on Oracle or MSSQL...
>
> Best regards,
>
> Anastasios Papadopoulos
>
> Αναστάσιος Παπαδόπουλος
> Software Solutions Architect
> SalesManager Hellas
> Customer Relationship Management Solutions
> Τηλ.: (+30) 210 6083485
> Φαξ: (+30) 210 6018453
> e-mail: [Email address protected]
> www.salesmanager.gr
>
>
> -----Original Message-----
> From: Rahul Chaudhari [mailto:mysqldba-ezmlmshield-x38539937.[Email address protected]
> Sent: Monday, October 29, 2007 11:56 AM
> To: LazyDBA Discussion
> Subject: Re: Multiple Rows
>
> I think he wants in oracle an not in mysql database.
>
> Regards,
> Rahul Chaudhari
> ----- Original Message -----
> From: "ΑναστάσιΞÎΟ‚ Ξ Ξ±Ο€Ξ±Ξ΄ΟŒΟ€ΞÎΟ…Ξ»ΞÎΟ‚ "
> <mysqldba-ezmlmshield-x19150961.[Email address protected]
> To: "LazyDBA Discussion" <[Email address protected]
> Sent: Monday, October 29, 2007 1:12 PM
> Subject: RE: Multiple Rows
>
>
>
>> You should try the group_concat function in MySQL, a great feature
>> missing in most RDBMS (AFAIK).
>>
>> HTH,
>>
>> Anastasios Papadopoulos
>>
>> ΓÂΓÂΓʽóôÜóéïò ΓÂΓʽΓ°ΓʽΓüðïáëïò
>> Software Solutions Architect
>> SalesManager Hellas
>> Customer Relationship Management Solutions
>> Ôçë.: (+30) 210 6083485
>> Γ–ΓʽΓ: (+30) 210 6018453
>> e-mail: [Email address protected]
>> www.salesmanager.gr
>>
>> -----Original Message-----
>> From: Spencer Gregory A IT2 (LAS CC)
>> [mailto:mysqldba-ezmlmshield-x30149568.[Email address protected]
>> Sent: Sunday, October 28, 2007 9:45 PM
>> To: LazyDBA Discussion
>> Subject: Multiple Rows
>>
>> I have an assignment to create a Movies database with the movie listed
>> along with the actors. My problem is I need to display each movie one
>> time along with all the actors;
>>
>>
>>
>> Cold Mountain- Jude Law, Nicole Kidman
>>
>>
>>
>> Enemy at the Gates- Jude Law, Rachel Weisz
>>
>>
>>
>> But what I get is like this;
>>
>>
>>
>> Cold Mountain- Jude Law
>>
>> Cold Mountain- Nicole Kidman
>>
>> Enemy at the Gates- Jude Law
>>
>> Enemy at the Gates- Rachel Weisz
>>
>>
>>
>> How do I avoid displaying duplicating the movie title?
>>
>>
>>
>>
>>
>>
>>
>> Very respectfully,
>>
>> IT2 Spencer
>>
>> CCNA
>>
>> [Email address protected]
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>> To unsubscribe, e-mail: mysqldba-[Email address protected]
>> Website : http://www.LazyDBA.com
>>
>>
>>
>> ---------------------------------------------------------------------
>> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>> To unsubscribe, e-mail: mysqldba-[Email address protected]
>> Website : http://www.LazyDBA.com
>>
>>
>>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mysqldba-[Email address protected]
> Website : http://www.LazyDBA.com
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mysqldba-[Email address protected]
> Website : http://www.LazyDBA.com
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mysqldba-[Email address protected]
> Website : http://www.LazyDBA.com
>
>
>
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mysqldba-[Email address protected]
Website : http://www.LazyDBA.com
MySQL LazyDBA home page