Skip navigation links

MySQL Forums :: General :: Spinning rows into columns, in a view. Is it possible?


Advanced Search

Spinning rows into columns, in a view. Is it possible?
Posted by: Bryce Nesbitt ()
Date: March 11, 2006 06:43PM

I have some tables in SQL, with rows that represent a measurement for a location, at a particular date:

location date value
1 jan 103
2 jan 123
1 feb 861
4 feb 69

I would like to offer a "view" into this table, for spreadsheet users, via ODBC. Is there a way to automatically reformat data in this view, so spreadsheet users can easily plot it?

Something like:

--- #1 #2 #3 #4
jan 103 123 99 33
feb 861 511 6 69

Options: ReplyQuote


Subject Written By Posted
Spinning rows into columns, in a view. Is it possible? Bryce Nesbitt 03/11/2006 06:43PM
Re: Spinning rows into columns, in a view. Is it possible? Peter Brawley 03/11/2006 10:19PM
Re: Spinning rows into columns, in a view. Is it possible? Bryce Nesbitt 03/13/2006 12:12PM
Re: Spinning rows into columns, in a view. Is it possible? Tushar Sambare 09/25/2008 10:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.