nesting

Does MySQL Support Nested Transactions? Transactions cannot be nested. This is a consequence of the implicit commit performed for any current transaction when you issue a START TRANSACTION statement or one of its synonyms. MySql doesn’t support nested transactions. … A simpler solution is to ignore the second begin transaction and instead increase a counter.