Rory McKinley <[EMAIL PROTECTED]> wrote on 02/09/2006 07:37:17 AM: > 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 >
Use a "prepared statement". Build your SQL statement as a string, prepare it, and execute it. It's all right there in the manual. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
