MySQL Engines: MyISAM vs. InnoDB

Reading a good article about - MySQL engines - MyISAM vs. InnoDB

Learned that InnoDB provides increased concurrency, enhanced performance and much more data integrity than MyISAM. If you need to put your statements in transaction, InnoDB engine is the right choice. MyISAM is known for its simplicity. It also uses less memory. The best part is that in one database, you can have "mix and match" table engines.

Syntax to swtich db engines:
ALTER TABLE tablename ENGINE = INNODB/MYISAM;