Boki, problem je što MySQL
IMA begin/rollback koji ti pominješ.
Kôd:
start transaction;
insert into foo value ('foo1');
insert into foo value ('foo2');
commit;
start transaction;
insert into foo value ('foo3');
insert into foo value ('foo2');
;duplicate key error occured
rollback;
Ovo radi sa Innodb i BDB tabelama!