Hello.
Similar question was asked recently. See:
http://lists.mysql.com/mysql/187940
Mark Ahlstrom <[EMAIL PROTECTED]> wrote:
> Would anyone have a good idea on how to change rows to columns? I'm
> creating a report where I have counts per hour. I can produce
> +--+---+
> |
[snip]
Would anyone have a good idea on how to change rows to columns? I'm
creating a report where I have counts per hour. I can produce
+--+---+
| hour | count |
+--+---+
|0 | 1 |
|1 | 0 |
|2 | 1 |
|3 | 0 |
|4 | 0 |
And then tack on an add