DatabaseLink`
DatabaseLink`

SQLBeginTransaction

SQLBeginTransaction[conn]

initiates an SQL transaction.

更多信息和选项

  • To use SQLBeginTransaction, 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:

Select the data: