Re: Stored procedures using a variable tablename

2005-11-07 Thread Stefano Obliquid
Hello everybody, Rhino answer to "Evaluating text as an expression" and he solves my problem too. I need a prepared statement to execute dynamic sql. I understand that I cannot pass a tablename as a parameter value, since it's not a value, so I have to prepare my sql separately. I tried thi

Stored procedures using a variable tablename

2005-11-06 Thread Stefano Obliquid
Hello, I am moving my first steps with stored procedures in Mysql and I was trying to write a stored procedure using a tablename given as a variable. In this example the local variable m_sequence has the value of the table I want to use. CREATE PROCEDURE p_new_id (IN tablename VARCHAR(128), O