Ends the current transaction and makes all changes that occurred during the transaction permanent and visible to other users.
COMMIT is a synonym for
COMMIT [ WORK | TRANSACTION ]
Optional keywords for readability only.
This example shows how to commit an insert.
=> CREATE TABLE sample_table (a INT); => INSERT INTO sample_table (a) VALUES (1); OUTPUT -------- 1 => COMMIT;