Pros and Cons of MySQL Table Types

Of all the positive things that MySQL brings to the table, probably the most overlooked is multiple table types. This facet of the application is overlooked as a feature and more importantly is overlooked at design time.

MySQL has six distinct table types.

• MyISAM
• MERGE
• ISAM
• HEAP
• InnoDB
• BDB or BerkeleyDB Tables

Finding a transaction table that's just my type

Two of these table types currently support transactions. Transactions give the user greater control when working with data. You would use syntax similar to the following for a manual transaction.

The article continues at http://www.developer.com/db/article.php/2235521