Showing entries 1 to 1
Displaying posts with tag: implicit (reset)
Feb
03
2011
Implicit COMMIT considered harmful.
Posted by Stewart Smith on Thu 03 Feb 2011 22:57 UTC
Tags:

If you execute the following, what does your RDBMS do? 

CREATE TABLE t1 (a int);
START TRANSACTION;
INSERT INTO t1 (a) VALUES (1);
START TRANSACTION;
INSERT INTO t1 (a) VALUES (2);
ROLLBACK;
SELECT * FROM t1;

The answer may surprise you.

Showing entries 1 to 1