MySQL Transactions

This works as expected:

START TRANSACTION;
INSERT INTO artist VALUES(8, "The Cure");
INSERT INTO album VALUES (8, 1, "Disintegration");
ROLLBACK;
-- COMMIT;


[Summarized from Learning MySQL]