MySQL Table Types

[mihkel100]

What are the differences of different table types that MySQL offers? I mean MyISAM, which is the default table type, InnoDB, BDB and Heap.

[devinemke]

http://dev.mysql.com/doc/mysql/en/Table_types.html

[mihkel100]

Originally posted by devinemke
http://dev.mysql.com/doc/mysql/en/Table_types.html

Unfortunately, there isn't explained the differences very well.

I'd like to know which type of table should I use when I make different applications (e.g. changable news, forum, guestbook, dynamic menu etc). It would be nice if someone explains that. Thanks.