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