MySQL Forums
Forum List  »  Stored Procedures

Re: Error on variable when running a procedure
Posted by: Rick James
Date: November 21, 2013 05:19PM

`foo` is a literal -- so substitution done.

You will need to construct the SELECT statement using CONCAT to fill in the column name and table name. Then use PREPARE and EXECUTE to 'run' the SELECT.

Options: ReplyQuote


Subject
Views
Written By
Posted
2215
November 19, 2013 10:31AM
Re: Error on variable when running a procedure
836
November 21, 2013 05:19PM


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.