DatabaseLink`
DatabaseLink`

SQLRollbackTransaction

SQLRollbackTransaction[conn]

terminates an SQL transaction.

SQLRollbackTransaction[conn,savepoint]

returns to an SQLSavepoint.

更多信息和选项

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

Roll back previous inserts:

Commit the transaction:

The table only contains data inserted after the rollback:

Begin another transaction:

Insert data:

Create a savepoint:

Insert more data:

Roll back to the savepoint:

Commit the transaction:

The table only contains data inserted up to the savepoint: