SQL/MySQL/Transaction/TRANSACTION COMMIT

Using TRANSACTION and COMMIT

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;