Are nested transactions allowed in MySQL?

Question

Simple doubt, the title says it all. =)

Answer 1

InnoDB supports SAVEPOINTS.

You can do the following:

CREATE TABLE t_test (id INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;

START TRANSACTION;

INSERT
INTO    t_test
VALUES  (1);

SELECT  *
FROM    t_test;

 id
---
  1

SAVEPOINT tran2;

INSERT
INTO    t_test
VALUES  (2);

SELECT  *
FROM    t_test;

 id
---
  1
  2

ROLLBACK TO tran2;

SELECT  *
FROM    t_test;

 id
---
  1

ROLLBACK;

SELECT  *
FROM    t_test;

 id
---

Answer 2

Have you tried it? It should only take you a few seconds, and then you would have your answer.

Answer 3

Actually they started to do:

Nested transaction scopes were not supported. MySQL Connector/NET 6.3.xx now implements nested transaction scopes. A per-thread stack of scopes is maintained, which is necessary in order to handle nested scopes with the RequiresNew or Suppress options.

http://dev.mysql.com/doc/refman/5.5/en/connector-net-news-6-3-0.html