set autocommit=0;

start transaction;
insert into artist values (8, "the cure");
insert into album values (8,1,"Disintegration");
rollback;

start transaction;
insert into artist values (8, "the cure");
insert into album values (8,1,"Disintegration");
commit;