WOLFRAM

Wolfram Language & System Documentation Center

SQLBeginTransaction[conn]

initiates an SQL transaction.

Details and Options
Details and Options Details and Options
Examples  
Basic Examples  
See Also
Tech Notes
Related Guides
DatabaseLink`
DatabaseLink`

SQLBeginTransaction

SQLBeginTransaction[conn]

initiates an SQL transaction.

Details and Options

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

Examples

Basic Examples  (1)

Wolfram Language code: Needs["DatabaseLink`"]

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:

Wolfram Language code: conn = OpenSQLConnection["demo"]
Wolfram Language code: SQLCreateTable[conn, SQLTable["TEST"], {SQLColumn["X", "DataTypeName" -> "Integer"], SQLColumn["Y", "DataTypeName" -> "Integer"]}];

Begin a transaction:

Wolfram Language code: SQLBeginTransaction[conn]

Insert data:

Wolfram Language code: SQLInsert[conn, "TEST", {"X", "Y"}, {61, 80}];
Wolfram Language code: SQLInsert[conn, "TEST", {"X", "Y"}, {72, 5}];

Commit the transaction:

Wolfram Language code: SQLCommitTransaction[conn]

Select the data:

Wolfram Language code: SQLSelect[conn, "TEST"]
Wolfram Language code: SQLDropTable[conn, "TEST"];
Wolfram Language code: CloseSQLConnection[conn];