MySQL Input Parameters Add Flexibility to Crosstab Stored Procedures
Posted
on Internet.com
See other posts from Internet.com
Published on Wed, 07 Apr 2010 04:00:00 +0100
Indexed on
2010/04/07
12:43 UTC
Read the original article
Hit count: 337
Filed under:
When generating a result set where the query contains an unknown number of column and/or row values we can use a combination of Prepared Statements, which allows us to tailor the output based on the number of data values. We can also add input parameters to a procedure to assign the field names, aliases, and even the aggregate function!
© Internet.com or respective owner