WOLFRAM

Wolfram Language & System Documentation Center
Wolfram Language Home Page »
DatabaseLink`
DatabaseLink`

SQLSavepoint

SQLSavepoint[…]

is an object that represents a savepoint in an SQL transaction.

Details and Options

  • To use SQLSavepoint, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • SQLSetSavepoint returns an SQLSavepoint object.
  • 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.
  • The following option can be given:
  • "Name"""the name of the savepoint

Examples

Basic Examples  (1)Summary of the most common use cases

In[1]:=1
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-j5qpz

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:

In[2]:=2
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-8bqgua
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-i2y

Begin a transaction:

In[4]:=4
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-yqk

Insert data:

In[5]:=5
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-g6h

Create a savepoint:

In[6]:=6
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-texupz
Out[6]=6

Insert more data:

In[7]:=7
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-xrp2s

Roll back to the savepoint:

In[8]:=8
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-7vq4qr

Commit the transaction:

In[9]:=9
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-ct2vlx

The table only contains data inserted up to the savepoint:

In[10]:=10
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-of8r5l
Out[10]=10
In[11]:=11
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-uv3
In[12]:=12
✖
https://wolfram.com/xid/09wx86mjtn1l1m8sy-kzo