Passing db names to a stored proc in MySQL 5

[Rory McKinley]

Hello List

I have tried dynamically assigning a database name to a stored proc via 
its parameter list:

CREATE STORED PROCEDURE testStoredProc (IN test_db_name CHAR)
        BEGIN
        SELECT * FROM test_db_name.test_table;
        END;

MySQL does not resolve test_db_name to the value passed in the 
parameter, and the query fails because there is no database with that name.

Is there any way around this?

Regards

Rory

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]