Stored Proceedure Variable Questions

[Martin Weaver]

Ok this question should be relatively simple.

MySQL, using a stored procedure, can you use the variable you are inputting as a table name in a create statement inside the stored procedure?


Here is what i have written thus far:

CREATE PROCEDURE Back_table(IN tblnme CHAR(15))
BEGIN
Create Table tblnme (stored VARCHAR(20), backed VARCHAR(20),
logged int, pallet CHAR(5), tray char (5), tag int);
END //

When i execute the stored procedure it creates a table with the name tblnme, but i want it to use the char input as the file name. So what did i miss here?