COMMIT (and
START TRANSACTION) is supported only within stored procedures. You cannot use
COMMIT or
START TRANSACTION within the SQL Editor. (SQL Editor sets AUTOCOMMIT to “on.”)
You may execute multiple START TRANSACTION statements to start nested transactions, but the outermost
COMMIT controls whether any nested committed blocks are committed or rolled back. For example, if transactions are nested five levels, then five
COMMIT statements are needed to commit all of the transactions.
COMMIT does not release any lock until the outermost transaction is committed.
COMMIT and
COMMIT WORK perform the same functionality.