MySQL Transactions
Topics
- What is a transaction?
- ACID properties
- Transaction support in MySQL
- Savepoints
- Transaction isolation levels
- Table locks
What is a Transaction?
- A transaction is a sequential group of database manipulation operations, which is performed as if it were one single work unit.
- Example: Transfer $100 from Savings account to Checking account is made of two update operations - these two operations need to be performed as a single unit
- Update Savings table
- Update Checking table
Download course content