H2 Database - Commit

H2 Database - Commit

COMMIT is a command from the SQL grammar used to commit the transaction. We can either commit the specific transaction or we can commit the currently executed transaction.

Syntax

There are two different syntaxes for COMMIT command.

Following is the generic syntax for the commit command to commit the current transaction.

COMMIT [ WORK ] 

Following is the generic syntax for the commit command to commit the specific transaction.

COMMIT TRANSACTION transactionName

Example 1

In this example, let us commit the current transaction using the following command.

COMMIT

The above command produces the following output.

Committed successfully

Frequently Asked Questions