Create TEMPORARY Table using dynamic SQL

[John Noble]

Hi folks,

I am trying to create a Temporary table using variables

If I use:
CREATE TEMPORARY TABLE tempTable SELECT * FROM myTable;
it will work fine,

Except, I don't know the name of the table in advance. That is passed into the sproc.

So I need to use something more dynamic like

SET @vTableName= CONCAT("tableName", variableName);
SET @vSQL = CONCAT("SELECT * FROM ", @vTableName);
CREATE TEMPORARY TABLE tempTable @vSQL;

Except this wont compile.

Is there a way around this?

Thanks,

JOhn