Re: Variables in Queries (Stored Procedures)

[Rafal Zdziech]

Try this :)


SET @tbname="tbname";

SELECT concat('SELECT ','a',' FROM', @tbname) INTO @VAR;

PREPARE STMT FROM @VAR;
EXECUTE STMT;

Fell free to use....