How do you change rows to columns?

2005-08-25 Thread 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

How do you become a MySQL DBA

2005-05-31 Thread 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 n