Re: Create TEMPORARY Table using dynamic SQL

[John Noble]

Hi folks,

I managed to get a workaround for this...

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

I just changed the SQL to :
SET @vSQL = CONCAT("CREATE TEMPORARY TABLE AS SELECT * FROM ", @vTableName);

Thanks,

John