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 +'"'

EXEC(@sql)

Find more posts tagged with

Accepted answers

Prajwal

https://dojo.domo.com/t5/New-to-Domo-and-Admin-questions/How-to-write-dynamic-sql-query-in-dataflow/td-p/31216

Here is the solutions

All comments

Prajwal

Trying to achieve something like this using domo MySQL - Dataflow

SELECT @select:='SELECT * FROM '
SELECT @table:='`table_name`'
SELECT @sql:= CONCAT(@select,@table)
PREPARE dynamic_statement FROM @sql;
EXECUTE dynamic_statement;
DEALLOCATE PREPARE dynamic_statement;

Prajwal

https://dojo.domo.com/t5/New-to-Domo-and-Admin-questions/How-to-write-dynamic-sql-query-in-dataflow/td-p/31216

Here is the solutions