Multi Level Transaction (InnoDB)

[Harta Teo]

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

Thanks.