Start a TRANSACTION
CREATE TABLE table1(colA INTEGER, colB INTEGER); START TRANSACTION; UPDATE table1 SET colB=11 WHERE colA=1; COMMIT; drop table table1;