> > 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
> > Is there any way around this?
> Use a "prepared statement". Build your SQL statement as a string, prepare
> it, and execute it. It's all right there in the manual.
Indeed, I stand corrected.
says that this is now possible in Stored Procedures :-)
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!