Warning
•The idea of a transaction is
hard to see when interacting directly with DBMS, instead of from
an app program
•Using an interactive query interface to DBMS,
by default each SQL statement is treated as a separate
transaction (with implicit COMMIT at end) unless you explicitly
say “START TRANSACTION”