Re: dynamic table name

2009-04-26 Thread Peter Brawley
DECLARE my_table CHAR(32); SET my_table = UNIX_TIMESTAMP(); CREATE TABLE my_table See the manual page for PREPARE. PB - Mauricio Tellez wrote: Hi, I'm creating a stored procedure and inside this procedure I have a CREATE TABLE statement, but I want to make a dynamic table for

dynamic table name

2009-04-26 Thread Mauricio Tellez
Hi, I'm creating a stored procedure and inside this procedure I have a CREATE TABLE statement, but I want to make a dynamic table for this table. Also, this table name is passed as a parameter for another SP, but instead of get the value of the parameter, I got the name of the parameter. For exampl