Re: How to Exec variable contenting SQL statement in Procedure?

[Andrew Gilfrin]

The most obvious solution to this would be to build functions outside of MySQL which builds the select statment as a string (if your simply doing this to return dynamic results).

I assume you would have been calling these stored procedures from another language anyway so write the code in that layer rather than MySQL stored procedues. Even in a language such as PL/SQL or T-SQL there is no advantage other than a central point of storage to write a procedure in this way.

Perhaps if you told us why you want to do this then it might help give a better answer.

Andrew Gilfrin
http://www.mysqldevelopment.com