MySQL Forums
Forum List  »  Newbie

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


Check this site on creating a dynamic crosstab queries.

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.


Options: ReplyQuote

Written By
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.