-
MySQL Input Parameters Add Flexibility to Crosstab Stored Procedures
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!
This story continues at http://www.databasejournal.com/featu...Procedures.htm
_______________
Thanks,
Linda
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|