has anyone had any luck creating dynamic columns in mysql
what I'm trying to do is for sql to check and see if a column missing, if it is then i want sql to create the column. I've done several attempts with no luck. the alter table add column sql works but it fails when i add it to the if condition.
any thoughts?
CREATE PROCEDURE addcol() BEGIN
IF NOT EXISTS(
SELECT * FROM information_schema.COLUMNS
WHERE COLUMN_NAME="new_column" AND TABLE_NAME="transform_data_1"
)
THEN
ALTER TABLE `transform_data_1`
ADD COLUMN `type` INT NOT NULL
END IF
//
CALL addcol();
DROP PROCEDURE addcol;
Comments
-
@BeastMode since you're asking a mysql question, stack overflow would probably be your best bet.
but... let's close the loop here. why you trying to dynamically add 'missing columns'?
how are you defining what's 'missing'?
buuuut before we even address that question.
if i had to quess you're trying to union multiple datasets together with different schemas.
if that's the case, you'll get faster performance doing a UNION operation using Magic 2.0
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 549 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 545 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 9 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive