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.
- 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