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;

Tagged:

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴

    @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"