Take the 2-minute tour ×  What is the difference between
Transactional and Non-transactional tables? And How will the sql
query go if I want to create them?  Also when to use
transactional or non-transactional tables?.  share|improve this
question What did you not understand in the documentation? – 
Oded Apr 29 '12 at 8:52 Really? You can't google for it
yourself? It isn't hidden. –  Oded Apr 29 '12 at 9:05 add
comment  migrated from stackoverflow.com Apr 30 '12 at 14:24
This question came from our site for professional and enthusiast
programmers.  2 Answers  up vote 1 down vote accepted
Transactional table means, if data manipulation done with in
transaction then rollback / commit will work.  For Non
Transactional table, You need to rollback the changes with
manual code. No Impact of rollBack and commit. These tables are
useful for performing the statements with high performance.   If
you are using a transaction-safe storage engine (such as InnoDB,
BDB, or NDB Cluster), you can disable autocommit mode with