1COMMIT()                         SQL Commands                         COMMIT()
2
3
4

NAME

6       COMMIT - commit the current transaction
7
8

SYNOPSIS

10       COMMIT [ WORK | TRANSACTION ]
11
12

DESCRIPTION

14       COMMIT  commits the current transaction. All changes made by the trans‐
15       action become visible to others and are guaranteed to be durable  if  a
16       crash occurs.
17

PARAMETERS

19       WORK
20
21       TRANSACTION
22              Optional key words. They have no effect.
23

NOTES

25       Use ROLLBACK [rollback(7)] to abort a transaction.
26
27       Issuing  COMMIT when not inside a transaction does no harm, but it will
28       provoke a warning message.
29

EXAMPLES

31       To commit the current transaction and make all changes permanent:
32
33       COMMIT;
34
35

COMPATIBILITY

37       The SQL standard only specifies the two forms COMMIT and  COMMIT  WORK.
38       Otherwise, this command is fully conforming.
39

SEE ALSO

41       BEGIN [begin(7)], ROLLBACK [rollback(l)]
42
43
44
45SQL - Language Statements         2008-06-08                          COMMIT()