In a transaction , if a sql command invite an error , all commands before this command will be rollbacked , and the transaction reset and restart.
For example:
BEGIN
insert t1 values(1);
delete from t2
insert t1 values(2);
commit
if table t2 doesn't exist , "delete from t2" invites an error , and the insert will be rollbacked .
How can I prevent the rollback even when an error occurs ? Thanks
