Showing content from http://reference.wolfram.com/language/DatabaseLink/ref/SQLRollbackTransaction.html below:
SQLRollbackTransaction—Wolfram Documentation
WOLFRAM Consulting & Solutions
We deliver solutions for the AI eraâcombining symbolic computation, data-driven insights and deep technical expertise
- Data & Computational Intelligence
- Model-Based Design
- Algorithm Development
- Wolfram|Alpha for Business
- Blockchain Technology
- Education Technology
- Quantum Computation
WolframConsulting.com
Details and Options
- 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.
Examples Basic Examples (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:
RetroSearch is an open source project built by @garambo
| Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4