1COMMIT(7) SQL Commands COMMIT(7)
2
3
4
6 COMMIT - commit the current transaction
7
8
10 COMMIT [ WORK | TRANSACTION ]
11
12
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
19 WORK
20
21 TRANSACTION
22 Optional key words. They have no effect.
23
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
31 To commit the current transaction and make all changes permanent:
32
33 COMMIT;
34
35
37 The SQL standard only specifies the two forms COMMIT and COMMIT WORK.
38 Otherwise, this command is fully conforming.
39
41 BEGIN [begin(7)], ROLLBACK [rollback(7)]
42
43
44
45SQL - Language Statements 2014-02-17 COMMIT(7)