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.
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.