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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]