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)
0
Best Answer
Answers
Categories
- 7.7K All Categories
- 12 Connect
- 925 Connectors
- 247 Workbench
- 441 Transform
- 1.7K Magic ETL
- 61 SQL DataFlows
- 456 Datasets
- 88 Visualize
- 222 Beast Mode
- 2.1K Charting
- 8 Variables
- 5 Automate
- 349 APIs & Domo Developer
- 85 Apps
- Workflows
- 17 Predict
- 3 Jupyter Workspaces
- 14 R & Python Tiles
- 242 Distribute
- 60 Domo Everywhere
- 241 Scheduled Reports
- 18 Manage
- 39 Governance & Security
- 46 Product Ideas
- 1.1K Ideas Exchange
- 6 Community Forums
- 19 Getting Started
- 6 Community Member Introductions
- 50 Community News
- 18 Event Recordings
- 577 日本支部