DatabaseLink`
DatabaseLink`

SQLCommitTransaction

SQLCommitTransaction[conn]

commits an SQL transaction.

Details

  • To use SQLCommitTransaction, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • A group of SQL commands grouped into a transaction will only take effect permanently when the transaction is committed. The transaction can be canceled or returned to a savepoint.

Examples

Basic Examples  (1)

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the "DatabaseLink`DatabaseExamples`" package, as described in Using the Example Databases.

Open a connection:

Begin a transaction:

Insert data:

Commit the transaction: