I'd really suggest looking at the data model that requies you to
dynamically select which table to read from, and find another
way. If there are several tables that have the same column that
differ only by name, why not make the name a column?
-Jason Martin
On Sat, Nov 19, 2005 at 02:28:41PM
Hello.
Have a look here:
http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html
For a pity prepared statements are disabled now in stored routines:
http://dev.mysql.com/doc/refman/5.0/en/routine-restrictions.html
AESYS S.p.A. [Enzo Arlati] wrote:
I need to pass to
I need to pass to a stored procedure a var a table name.
But I don't known how use the variable in the sql statement.
If I use the method described belowe I get an error, the procedure use the
variable name as the name of the table.
Someone can help ?
CREATE FUNCTION `myFunc`( tbl_name