List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:January 16 2004 7:18am
Subject:Re: Multi Level Transaction (InnoDB)
View as plain text  
In the last episode (Dec 31), Harta Teo said:
> Just wondor how InnoDB handle Multi Level Transaction, For example,
> DELETE FORM table1 WHERE id = 123
> BEGIN    <---- New Transaction Level 2
> DELETE FROM table1 WHERE id = 234
> COMMIT <--- Level2
> ROLLBACK <---Level1

The manual ( ) 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

	Dan Nelson
Multi Level Transaction (InnoDB)Harta Teo16 Jan
  • Re: Multi Level Transaction (InnoDB)Dan Nelson16 Jan
    • Re: Multi Level Transaction (InnoDB)Chris Nolan16 Jan