Autocommit

[neoform]

if autocommit is on by default and I want to use transactions sometimes, do i need to turn off autocommit before starting a transaction (then turn it back on after the commit/rollback), or does it assume it needs to see a commit/rollback before resuming autocommit mode?

 

eg. is this required?

 

set autocommit=0;
start transaction;
#stuff
commit;
set autocommit=1;