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

You must have an active subscription to download PDF,Lab Zip and Recordings of this course topic.Please click the "Subscribe" button or the "Login" button if you already have an account.