Re: Stored procedures using a variable tablename

to do this? Thankyou Stefano Locati - Obliquid http://software.obliquid.com Stefano Obliquid wrote: 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

Stored procedures using a variable tablename

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),