Change database engine

You can specify the database engine type you want to use, during table creation using the query :

-------------
CREATE TABLE table_name (a INT, b CHAR (20)) ENGINE=InnoDB;
------------

If the table already exists use the query given below.

----------------
ALTER TABLE 'table_name' Engine=InnoDB charset=utf8 collate=utf8_bin;
----------------