Here’s how to use savepoint() function.
Description:
Set the savepoint to which you can later rollback.
Syntax:
db.savepoint(spn)
Note:
The function creates a save point named spn. The save point name must not be omitted and repeated
Parameter:
|
db |
Database connection |
|
spn |
Savepoint name |
Return value:
Boolean
Example:
|
|
A |
|
|
1 |
=connect("demo") |
|
|
2 |
=A1.savepoint("num1") |
Set a savepoint named "num1" |