Can we use variable and temporary tables in MySQL data flow ? Something similar to storeprocedure?


Here is the problem that i am currently facing.

I need to Alter table column name at run time dynamically being based on some dataset mapping. Is there a way I could use variable, temporary table or store procedure in MySQL Data Flow so that i can create a dynamic ALTER statement and execute it? 

Following is what I am trying to get done. 

Declare @sql VARCHAR(MAX) 

DECLARE @sql1 varchar(max) 

declare @columnname varchar(400) = 'columnName1'

SET @sql = 'alter table tablename rename column "oldcolname" to "

'+ @columnname +'"'