Hi,

I have a table Faculty where the SQL "SELECT * FROM Faculty;" works fine.

I would like to have the table "Faculty" be retrieved from a session
variable. I tried the following and it didn't work. Help would be
appreciated.

Thanks,
Joe

===================================
mysql> SET @MYTABLE='Faculty';

Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM @MYTABLE;

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax
to use near '@MYTABLE' at line 1
mysql>
===================================

Joe Hesse <JoeHesse (AT) gmail (DOT) com> wrote:
This is called "dynamic SQL". MySQL supports that with the PREPARE and
EXECUTE statements:

SET @MYTABLE='Faculty';
....
SET @querystring=CONCAT('SELECT * FROM ', @MYTABLE);
PREPARE stmt1 FROM @querystring;
EXECUTE stmt1;

http://dev.mysql.com/doc/refman/5.1/...tatements.html


XL