Normal
We want to integrate the switch to innodb on MySQL upgrade and that a good finding because we run into 3 issues :Recording / Schedule about 767 bytes limits (you just fixed that).Now we need to be able to execute this above script if MySQL engine is higher then MySQL version 5.6 and only if current table is MyISAM.Are you able to provider such modification ?I have try something like that but i'm not SQL guru lol :[CODE]SELECT @@VERSION, IF(@@VERSION > '5.6',true, false) FROM information_schema.tables WHERE ENGINE = 'MyISAM';[/CODE]
We want to integrate the switch to innodb on MySQL upgrade and that a good finding because we run into 3 issues :
Recording / Schedule about 767 bytes limits (you just fixed that).
Now we need to be able to execute this above script if MySQL engine is higher then MySQL version 5.6 and only if current table is MyISAM.
Are you able to provider such modification ?
I have try something like that but i'm not SQL guru lol :
[CODE]SELECT @@VERSION, IF(@@VERSION > '5.6',true, false) FROM information_schema.tables WHERE ENGINE = 'MyISAM';[/CODE]
