Re: set the value of AS clause name in stored procedure

[Terry Warren]

Peter Brawley Wrote:
-------------------------------------------------------
> Dynamic query code needs PREPARE, see that topic
> in the manual.

thanks for the response, but I don't see how that would be different from passing values into a stored procedure. The PREPARED statement topic in the manual has the following:

"Within the statement, ? characters can be used as parameter markers to indicate where data values are to be bound to the query later when you execute it. The ? characters should not be enclosed within quotation marks, even if you intend to bind them to string values. Parameter markers can be used only where data values should appear, not for SQL keywords, identifiers, and so forth."

so it seems to be saying that what I want to do is not possible. In any case, I can accomplish what I want be capturing the output from the query and then replacing the header line as appropriate; I was just hoping that it could all be done within the MySQL statements themselves.