MySQL Forums
Forum List  »  General

Re: Pivot tables
Posted by: haydn flower
Date: May 03, 2012 06:33PM

You might want to check these articles by Rob Gravelle
http://www.databasejournal.com/features/mysql/article.php/3871556/MySQL-Prepared-Statements-to-Generate-Crosstab-SQL.htm
Rob creates a stored procedure that generates SQL code to create the Pivot/Crosstab Table.

A bit like the Wizard by Giuseppe Maxia and what Peter states on his site
here
http://www.artfulsoftware.com/infotree/queries.php#523

Options: ReplyQuote


Subject
Written By
Posted
L M
May 02, 2012 03:17PM
May 02, 2012 04:55PM
L M
May 02, 2012 04:59PM
May 03, 2012 09:53AM
Re: Pivot tables
May 03, 2012 06:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.