change engine to myisam mysql code example
Example 1: alter table engine mysql
ALTER TABLE table_name ENGINE=InnoDB;
Example 2: mysql change innodb to myisam
ALTER TABLE table_name ENGINE = MyISAM;
ALTER TABLE table_name ENGINE=InnoDB;
ALTER TABLE table_name ENGINE = MyISAM;