Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Commit

Ends the current transaction block and finalizes changes made within it.

Synopsis

COMMIT [ WORK | TRANSACTION ]

Parameters

WORK | TRANSACTION

A pair of optional noise keywords. They can be ignored, or used to make your SQL more readable.

Results

COMMIT

The message returned when the current transaction is successfully committed.

NOTICE: COMMIT: no transaction in progress

The notice returned if there is no current transaction for the COMMIT command to actually commit.

Description

Use the COMMIT command to finalize the current transaction. Once a COMMIT is performed, any modifications made by the transaction are saved into the database.

Note

Description

If something unintended happens during a transaction block, you can use the ROLLBACK command to abort the current transaction. This undoes the effect of any SQL executed after the last BEGIN statement.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint