Transactions

Switch autocommit off and begin a transaction:

BEGIN TRANSACTION;

Or simply:

BEGIN;

To save all results of the statements after the start of the transaction to disk:

COMMIT;

To reset the state of the database to before the beginning of the transaction:

ROLLBACK;