Mysql store procedure get table name as parameter

Question

I have a mysql procedure that inserts a row to a table. Is it possible to pass the name of the table as a parameter?

I tried and got an unknown table exception.

EDIT:

my procedure is called from insaid a trriger:

CREATE  PROCEDURE `blabla`(tableName VARCHAR(255), var1 VARCHAR(255), var2 VARCHAR(255), var3 VARCHAR(255))
BEGIN
            INSERT INTO tableName 
            SET
                var1 = var1,
                var2= var2,
                var3= var3;

END

the error: ERROR 1146: 1146: Table 'xxx_xx_admin.tableName' doesn't exist

Check: [13.5 SQL Syntax for Prepared Statements](http://dev.mysql.com/doc/refman/5.6/en/sql-syntax-prepared-statements.html). — wchiquito, Oct 07 '14 at 08:45

score 1 · Answer 1 · edited May 23 '17 at 10:33

1

It is possible, but only if you use dynamic SQL to build your SQL. MySQL implements this using PREPARE and EXECUTE.

See How To have Dynamic SQL in MySQL Stored Procedure and http://rpbouman.blogspot.de/2005/11/mysql-5-prepared-statement-syntax-and.html

edited May 23 '17 at 10:33

Community

1
1

answered Oct 07 '14 at 08:45

davek

22,499
9
75
95

Mysql store procedure get table name as parameter

1 Answers1