Help With Transactions

[ralphiooo]

Hi, i've been reading up on transactions and how to use them. From what i see i simply put BEGIN at the start and then COMMIT at the end.

The reason i'm using transactions is because i don't want updates to take effect until every update has been made. Therefore i'm wondering whether the database changes are committed if the user closes their browser half way through execution.

From what i see calling the rollback method reverts it to its original state but if the user closes their browser i have no way of calling the rollback method. Appreciate your help on this thanks.

 

[ChrisMacPherson]

Hello,

I am getting going with transactions too at the moment. If you look at his part of the manual it explains it quite well.

http://dev.mysql.com/books/mysqlpress/mysql-tutorial/ch10.html

Especially these lines in your case:

Note that if you manually type

start transaction;

normally nothing will be committed until you manually type

commit;

I would understand this to mean that if the user closed the browser, which killed the process running the sql, then unless it had got to the 'commit' statement then none of the other updates would be made.

Chris MacPherson