MySQL : Change Table Engine from MyISAM to Innodb

mysql-tutorials

Simple SQL Command to change the table engine from MyISAM to InnoDB and InnoDB to MyISAM.

InnoDB to MyISAM

alter table `test123` engine = ‘MyISAM’

MyISAM to InnoDB

alter table `test123` engine = ‘InnoDB

Related posts

Leave a Comment