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,
> 
> 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
Thread
Multi Level Transaction (InnoDB)Harta Teo16 Jan
  • Re: Multi Level Transaction (InnoDB)Dan Nelson16 Jan
    • Re: Multi Level Transaction (InnoDB)Chris Nolan16 Jan