List:General Discussion« Previous MessageNext Message »
From:Craig (OFT) Weston Date:January 22 2009 8:19pm
Subject:RE: Need to pivot rows into columns
View as plain text  
From: Attila [mailto:atteeela@stripped]
Sent: Thursday, January 22, 2009 3:06 PM
To: mysql@stripped
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!
--
Attila
Software Developer
atteeela@stripped


Hello,

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.

:)
Craig

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.

Thread
Need to pivot rows into columnsAttila22 Jan
  • RE: Need to pivot rows into columnsOFT)22 Jan
    • RE: Need to pivot rows into columnsmos22 Jan
  • Re: Need to pivot rows into columnsPeter Brawley23 Jan
    • Re: Need to pivot rows into columnsAttila1 Feb