SQL/MySQL/Transaction/TRANSACTION COMMIT
Using TRANSACTION and COMMIT
<source lang="sql">
Drop table Books;
CREATE TABLE Books (
ID SMALLINT NOT NULL PRIMARY KEY, Title VARCHAR(60) NOT NULL, Copyright YEAR NOT NULL
) ENGINE=INNODB;
START TRANSACTION; INSERT INTO Books VALUES (1, "Poet", 1934); INSERT INTO Books VALUES (2, "Ohio", 1919); COMMIT; select * from Books;
</source>