Six types of tables.
Table type Description
BDB A transaction-safe table that is managed by the Berkeley DB (BDB) handler.
The BDB handler also supports automatic recovery and page-level locking.
The BDB handler does not work on all the operating systems on which MySQL can operate.
For the most part, InnoDB tables have replaced BDB tables.
MEMORY A table whose contents are stored in memory.
InnoDB A transaction-safe table that is managed by the InnoDB handler.
ISAM A deprecated table type that was once the default table type in MySQL.
MERGE A virtual table that is made up of identical MyISAM tables.
MyISAM The default table type in MySQL.
MyISAM tables are not transaction safe, and they do not support full foreign key functionality.
Related examples in the same category