IF condition in mysql script

Question

I am trying to write a script to patch our mysql database. Something like this I can run:

If IsTargetVersion(1.1) 
THEN
ALTER TABLE t1 ENGINE = InnoDB;
END IF;

The funny thing I found about MySql is: it doesn't support if condition in script. I don't want to create a store procedure, call it and drop it in my script. That looks stupid...

Does anybody have better approach?

Thanks

Excuse my ignorance but what exactly is IsTargetVersion? — inhan
– inhan, Commented Mar 28, 2012 at 1:46

Devart · Accepted Answer · 2012-03-28 06:24:23Z

2

This (pattern) solution just a workaround which will help you to use IF condition in the MySQL scripts -

SET @s = IF(IsTargetVersion(1.1), 'ALTER TABLE t1 ENGINE = InnoDB', 'DO SLEEP(0)');
PREPARE stmt1 FROM @s;
EXECUTE stmt1;

answered Mar 28, 2012 at 6:24

Devart

120k23 gold badges171 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Click Ok Over a year ago

Your answer is amazing!

Collectives™ on Stack Overflow

IF condition in mysql script

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related