How do you change rows to columns?

[Mark Ahlstrom]

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 |
|5 | 0 |
|6 | 0 |
|7 | 2 |
|8 | 1 |
|9 | 0 |
|   10 | 1 |
|   11 | 0 |
|   12 | 0 |
|   13 | 0 |
|   14 | 0 |
|   15 | 0 |
|   16 | 0 |
|   17 | 1 |
|   18 | 0 |
|   19 | 1 |
|   20 | 1 |
|   21 | 0 |
|   22 | 0 |
|   23 | 0 |
+--+---+

And then tack on an additional column for each catagory I'm tracking.
However, I want to turn this horizontal and tack on each catagory as a
row.

Any ideas?

mediis

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How do you become a MySQL DBA

[Mark Ahlstrom]

Here's an odd question for you, how do you become a MySQL DBA?

I've got enough Solaris/Linux Experience under my belt and I was a Jr.
Oracle DBA for a year, which got me really interested in RDBMS. I try
to work with MySQL as much as possible, but I work with one of those
large telco's that does not like anything where they can't pay large
amounts of money. This means I have to work it into my spare time.

I've been trying to tie MySQL into basic services: ftp, DSPAM, pop3,
AND offer help for what we do have: running backups and repairing the
odd table when needed.

But the question is, what else could I do to help develope DBA skills?
 Right now I have very little data that goes beyond 2 tables, so my
query skills are withering.

mediis a t gmail d o t com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]