/* Chapter 12 - Examples */


CREATE TABLE Books
(
   BookID SMALLINT NOT NULL PRIMARY KEY,
   BookTitle VARCHAR(60) NOT NULL,
   Copyright YEAR NOT NULL
)
ENGINE=INNODB;


START TRANSACTION;
INSERT INTO Books VALUES (101, 'Letters to a Young Poet', 1934);
INSERT INTO Books VALUES (102, 'Winesburg, Ohio', 1919);
COMMIT;


START TRANSACTION;
INSERT INTO Books VALUES (103, 'Hell\’s Angels', 1966);
INSERT INTO Books VALUES (104, 'Black Elk Speaks', 1932);
ROLLBACK;


START TRANSACTION;
INSERT INTO Books VALUES (103, 'Hell\’s Angels', 1966);
INSERT INTO Books VALUES (104, 'Black Elk Speaks', 1932);
SAVEPOINT sp1;


START TRANSACTION;
INSERT INTO Books VALUES (103, 'Hell\’s Angels', 1966);
INSERT INTO Books VALUES (104, 'Black Elk Speaks', 1932);
SAVEPOINT sp1;
INSERT INTO Books VALUES (105, 'Noncomformity', 1996);
INSERT INTO Books VALUES (106, 'A Confederacy of Dunces', 1980);
ROLLBACK TO SAVEPOINT sp1;
INSERT INTO Books VALUES (107, 'Postcards', 1992);
INSERT INTO Books VALUES (108, 'The Shipping News', 1993);
COMMIT;