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

A full loan transaction

Arrange the full loan transaction in the correct order (top to bottom):

Items to put in order

  • START TRANSACTION;
  • UPDATE ksiazki SET dostepna = 0 WHERE id = 1;
  • INSERT INTO wypozyczenia (ksiazka_id, czytelnik_id, data_wypozyczenia) VALUES (1, 1, '2026-06-22');
  • COMMIT;

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