change table engine mysql code example

Example 1: alter table engine mysql

ALTER TABLE table_name ENGINE=InnoDB;

Example 2: change table to innodb mysql

ALTER TABLE `tbl` ENGINE=INNODB