Home >> FAQs/Tutorials >> MySQL Tutorials
MySQL Tutorial - What Is a Transaction - Unit of Work
(Continued from previous topic...)
What Is a Transaction?
A transaction is a logical unit of work requested by a user to be applied to the database objects.
MySQL server introduces the transaction concept to allow users to group one or more SQL statements
into a single transaction, so that the effects of all the SQL statements in a transaction can
be either all committed (applied to the database) or all rolled back (undone from the
The transaction concept only works on tables that use transaction-safe storage engines, like InnoDB and BDB.
For transaction-unsafe storage engines, like MyISAM, transaction will be ignored.
(Continued on next topic...)
- What Is a Transaction?
- How To Start a New Transaction?
- How To End the Current Transaction?
- How To Create a Table for Transaction Testing?
- How To Switch between Autocommit-On and Autocommit-Off Modes?
- How To Find Out the Current Transaction Mode?
- How To Start a New Transaction Explicitly?
- How To Commit the Current Transaction?
- How To Rollback the Current Transaction?
- What Happens to the Current Transaction If a START TRANSACTION Is Executed?
- What Happens to the Current Transaction If a DDL Statement Is Executed?
- What Happens to the Current Transaction If the Session Is Ended?
- What Happens to the Current Transaction If the Session Is Killed?
- How Does MySQL Handle Read Consistency?
- What Are Transaction Isolation Levels?
- How To View and Change the Current Transaction Isolation Level?
- What Is a Data Lock?
- How To Experiment Data Locks?
- How Long a Transaction Will Wait for a Data Lock?
- What Happens to Your Transactions When ERROR 1205 Occurred?
- What Is a Dead Lock?
- How To Experiment Dead Locks?
- What Happens to Your Transactions When ERROR 1213 Occurred?
- What Are Impacts on Applications from Locks, Timeouts, and DeadLocks?