table types in Mysql?

Question

what exactly are the transactional storage engines in MySQL ?? also please get me something in detail about the various table types for MySQL.....

Answer 1

http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html

Here you go, a full list of storage engines which MySQL supports (transactional and nontransactional). Some probably aren't enabled by default.