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>