MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Phil Evans Date:July 11 2003 3:11pm
Subject:columns to rows
View as plain text  
Hi there. I am a rank amateur at this trying to make sense out of a heap (and growing) of

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.

Thanking you,


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