Finalizes all changes made in a batched transaction.
- The COMMIT statement is used in conjunction with a START TRANSACTION statement.
- Non-atomic mutations aren't committed until the COMMIT command is called.
- When the COMMIT command is called, the changes made to the in-memory blockchain are written to disk and can't be rolled back.
- Committing a batched transaction increment the transaction count by 1.
A. Committing a non-atomic mutation.
This example uses the Financial Demo Database and commits the non-atomic insertion into
SET AUTOCOMMIT = 0
INSERT financial.companies VALUES ("MYL", "Mylan", "Health Care")