In the last episode (Dec 31), Harta Teo said:
> Just wondor how InnoDB handle Multi Level Transaction, For example,
>
> BEGIN
> DELETE FORM table1 WHERE id = 123
> BEGIN <---- New Transaction Level 2
> DELETE FROM table1 WHERE id = 234
> COMMIT <--- Level2
> ROLLBACK <---Level1
The manual ( http://www.mysql.com/doc/en/Implicit_commit.html ) says:
The following commands implicitly end a transaction (as if you had
done a COMMIT before executing the command): ... BEGIN ...
If you want multiple rollback levels, take a look at the SAVEPOINT
command: http://www.mysql.com/doc/en/Savepoints.html
--
Dan Nelson
dnelson@stripped
