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.