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 > +------+-------+ > | 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
