List:General Discussion« Previous MessageNext Message »
From:Robert DiFalco Date:April 10 2006 5:47pm
Subject:RE: Making result rows to one row
View as plain text  
Can you tell us more about the use case? Why does this need to be in a
single row? Maybe instead of figuring out how to get this into a single
row we could instead figure out how to solve the problem that requires
it to be in a single row. 

-----Original Message-----
From: Peter Lauri [mailto:peter@stripped] 
Sent: Monday, April 10, 2006 10:45 AM
To: mysql@stripped
Subject: Making result rows to one row

Best group member,

Many of you probably do not understand the question; neither would I if
someone ask me, so I will explain a little bit more.

This is what I have:

SELECT tps.strokes FROM tour_player_score tps join tour_scorecard_hole
tsh WHERE tour_player_id=175 AND tps.scorecard_hole_id=tsh.id ORDER BY
tsh.hole_number;

This generates this:

+---------+
| strokes |
+---------+
|       6 |
|       4 |
|       5 |
|       3 |
|       5 |
|       4 |
|       4 |
|       3 |
|       6 |
+---------+

I would like to retrieve it in one row instead of many rows with one per
row.

s1 s2 s3 s4 s5 s6 s7 s8 s9
6  4  5  3  5  4  4  3  6 

Can this be done?

Best regards,
Peter Lauri


Thread
Making result rows to one rowPeter Lauri10 Apr
RE: Making result rows to one rowRobert DiFalco10 Apr
  • RE: Making result rows to one rowPeter Lauri11 Apr
Re: Making result rows to one rowPeter Brawley10 Apr
  • RE: Making result rows to one rowPeter Lauri11 Apr
Re: Making result rows to one rowPeter Brawley11 Apr
  • RE: [SOLVED] Making result rows to one rowPeter Lauri12 Apr