END
Ends the current transaction and makes all changes that occurred during the transaction permanent and visible to other users.
Syntax
COMMIT [ WORK | TRANSACTION ]
Parameters
WORK | TRANSACTION |
Have no effect; they are optional keywords for readability. |
Privileges
None
Notes
COMMIT is a synonym for END.
Examples
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