Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 1 to 1 of 1 « Previous | Next »
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.