Ends the current transaction and makes all changes that occurred during the transaction permanent and visible to other users.
COMMIT [ WORK | TRANSACTION ]
WORK | TRANSACTION
Have no effect; they are optional keywords for readability.
COMMIT is a synonym for END.
This example shows how to end a transaction.
=> CREATE TABLE sample_table (a INT); => INSERT INTO sample_table (a) VALUES (1); OUTPUT -------- 1 => END; COMMIT