MySQL Forums
Forum List  »  Newbie

Re: generate columns out of data
Posted by: Chris Stubben
Date: March 14, 2006 10:23AM

Hi,

Check this site on creating a dynamic crosstab queries.

http://rpbouman.blogspot.com/2005/10/creating-crosstabs-in-mysql.html

Basically, use group_concat(category...) to create the IF(...='A')) statements and construct the query and then execute it in a procedure. It's possible.

Chris

Options: ReplyQuote


Subject
Written By
Posted
Re: generate columns out of data
March 14, 2006 10:23AM


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.