MySQL Storage engine

Reference from

Http://blog.chinaunix.net/uid-21411227-id-1826943.html

http://www.jb51.net/article/55849.htm

the storage engines provided by MySQL are: MyISAM、InnoDB、MERGE、MEMORY (HEAP)、BDB (BerkeleyDB)、EXAMPLE、Federated、ARCHIVE、CSV、blackhole。 You can use the show engines command to view MySQL-supported storage engines

SHOW ENGINES;

When creating a table, use the keyword engine or type to determine the type of storage engine for the table: (Preferred engine)

CREATE TABLE INT =  CREATETABLEINT= MEMORY;  

MySQL Storage engine