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.