MySQL Forums
Forum List  »  Stored Procedures

Re: set the value of AS clause name in stored procedure
Posted by: Terry Warren
Date: December 25, 2020 08:21AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: set the value of AS clause name in stored procedure
39
December 25, 2020 08:21AM


Sorry, only registered users may post in this forum.

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.