MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:July 11 2003 4:34pm
Subject:Re: columns to rows
View as plain text  
"Phil Evans" <pevans@stripped> wrote:
> Hi there. I am a rank amateur at this trying to make sense out of a heap (and
> growing) of data.
> 
> I have a resultset with this structure:
> 
> no    data    date
> 1    uyt    d1
> 1    klh    d2
> 1    oiu    d3
> 2    kjh    d1
> 2    kljh    d2
> 2    asd    d3
> 
> that I wish to convert to this structure.
> 
> no     d1    d2    d3
> 1     uyt    klh    oiu
> 2     kjh    kljh   asd 
> 
> Given that the original has over 100,000 records, I was hoping to find some
> reasonable way of doing it.

You can't do it with MySQL only.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




Thread
columns to rowsPhil Evans11 Jul
  • Re: columns to rowsharm11 Jul
    • Re: columns to rowsEmile State11 Jul
  • Re: columns to rowsVictoria Reznichenko11 Jul
RE: columns to rowsRudy Metzger14 Jul