How to change or convert MyISAM to InnoDB or vice versa?

• 
  MyISAM tables yield better performance results in selecting data records
• InnoDB tables give better performance results in inserting and updating data records

To change a MyISAM table to an InnoDB table:

ALTER TABLE table_name ENGINE = InnoDB;

To convert an InnoDB table to a MyISAM table:

ALTER TABLE table_name ENGINE = MyISAM;