Display Output

spotter

I'm looking for a query that can take a table with data in this format:

Expand|Select|Wrap|Line Numbers

 
id  name   date

1   data1  10-28-09

2   data1  10-28-09

3   data1  10-28-09

4   data2  10-29-09

5   data2  10-29-09

6   data2  10-29-09

7   data3  10-30-09

8   data3  10-30-09

9   data3  10-30-09

and return it in this format

Expand|Select|Wrap|Line Numbers

 10-28-09 10-29-09 10-30-09

data1    data2    data3

data1    data2    data3

data1    data2    data3

Any suggestions?

Atli

Hey.

No practical query can produce those results.

Having said that, you *could* probably get those results by using Stored Procedures and temporary tables, but I wouldn't recommend it. It would most likely be a major resource hog.

It is the job of your front-end applications to format the data for output, not the database itself. It is meant to store and retrieve the data, not display it.

Display Output

re: Display Output

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about