Chapter 26. Managing Transaction Processing
In this chapter you’ll learn what transactions are and how to use
ROLLBACK statements to manage transaction processing.
Understanding Transaction Processing
Not All Engines Support Transactions—. As explained in Chapter 21, “Creating and Manipulating Tables,” MySQL supports the use of several underlying database engines. Not all engines support explicit management of transaction processing, as will be explained in this chapter. The two most commonly used engines are
InnoDB. The former does not support explicit transaction management and the latter does. This is why the sample tables used in this book were created to use
InnoDB instead of the more commonly used
MyISAM. If you need ...