MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Error on variable when running a procedure
2407
bob dylan
November 19, 2013 10:31AM
Re: Error on variable when running a procedure
928
Rick James
November 21, 2013 05:19PM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.