MySQL cheatsheet: create a transaction

transactions.sql

-- Enabling and disabling automatic transactions

SET AUTOCOMMIT = 1; -- each SQL sentence is a transaction; i.e. it's automatically comitted into the actual DB (enabled by default)
SET AUTOCOMMIT = 0; -- SQL sentences are not automatically commited into the DB, so you must do it manually with the COMMIT instruction
COMMIT; -- commits a transaction

-- Running a transaction inside a stored procedure
START TRANSACTION;
    -- ... instructions of the transaction ...
COMMIT;