[dinke]

Boki, problem je što MySQL IMA begin/rollback koji ti pominješ.

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!