Put in order · SQL and MySQL course · Module 10: Transactions and advanced SQL

Steps of a safe transaction

Arrange the steps of a safe transaction in the correct order - from opening to commit:

Items to put in order

  • COMMIT (confirm all changes)
  • START TRANSACTION (open the transaction)
  • INSERT INTO wypozyczenia ... (save the loan)
  • UPDATE ksiazki SET dostepna = 0 ... (mark the book)

You can check the correct answer by solving this task in the CodeWorlds game.