Prepare statemnt using concat() in mysql giving error

insert, mysql, mysql-error-1064

Solution

Try this one please.

set @sql = concat('insert into ' , tableName ,  '(employee_id , administrator_id) values(? , ?) ' ) ; 
prepare stmnt1 from @sql;                
set @a = 19 ;
set @b = 11;
execute stmnt1 using @a , @b ;

deallocate prepare stmnt1;

Problem

The given below code is part of stored procedure (mysql 5.5.20): ``` prepare stmnt1 from concat('insert into ' , tableName , '(employee_id , administrator_id) values(? , ?) ' ) ; set @a = 19 ; set @b = 11; execute stmnt1 using @a , @b ; ``` `tableName` is local variable When i create procedure i get this error : ``` #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'concat('insert into ' , tableName , '(employee_id , administrator_id) values(? ' at line 23 ``` It seems that this kind of statement is not possible in mysql. Please help.Thanks.

Original source