User`s guide

7 Functions — Alphabetical List
7-196
rollback
Undo database changes
Syntax
rollback(conn)
Description
rollback(conn) reverses changes made to a database using fastinsert, insert, or
update via the database connection conn. The rollback function reverses all changes
made since the last commit or rollback operation. To use rollback, the AutoCommit
flag for conn must be off.
Note: rollback does not roll back data in MySQL databases if the database engine is
not InnoDB.
Examples
1
Ensure that the AutoCommit flag for connection conn is off by running:
get(conn,'AutoCommit')
ans =
off
2
Insert data contained in exdata into the columns DEPTNO, DNAME, and LOC, in the
table DEPT, for the data source conn.
fastinsert(conn, 'DEPT',...
{'DEPTNO';'DNAME';'LOC'}, exdata)
3
Roll back the data that you inserted into the database by running:
rollback(conn)
The data in exdata is removed from the database. The database now contains the
data it had before you ran the fastinsert function.