"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