From: Attila [mailto:atteeela@stripped]
Sent: Thursday, January 22, 2009 3:06 PM
Subject: Need to pivot rows into columns
I am using MySQL and have found some possibilities with SQL Server (Pivot,
crosstab, etc) ... but the requirements call for MySQL.
Is the above query possible?
Thanks a lot!
Look at http://dev.mysql.com/tech-resources/articles/wizard/print_version.html and
http://www.onlamp.com/pub/a/onlamp/2003/12/04/crosstabs.html?page=2 for ideas for
crosstabs. Some tools like TOAD for MYSQL have some functionality in this direction too.
This e-mail, including any attachments, may be confidential, privileged or otherwise
legally protected. It is intended only for the addressee. If you received this e-mail in
error or from someone who was not authorized to send it to you, do not disseminate, copy
or otherwise use this e-mail or its attachments. Please notify the sender immediately by
reply e-mail and delete the e-mail from your system.