DatabaseLink`
DatabaseLink`

SQLCommitTransaction

SQLCommitTransaction[conn]

commits an SQL transaction.

更多信息和选项

  • 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.

范例

基本范例  (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: