MyISAM query

[Trinity]

MyISAM is the default storage engine for MySQL , how can we change the default engine? I mean which other storage engine can we apply? Also the code ideally would be
CREATE TABLE t (i INT) ENGINE = MYISAM;
OR
CREATE TABLE t (i INT) TYPE = MYISAM;
So if we change the engine here we just have to replace MYISAM with the other word, or there is some other way?

 

[Deep]

yup, you just need to change the type only..

TYPE = InnoDB;

or

Heap, Merge, ISAM etc..

these are the different table types were present in my mysql installation..

there are few more types also, check out this page for details: *dev.mysql.com/doc/mysql/en/storage-engines.html

Deep