TRANSACTION and ROLLBACK : TRANSACTION ROLLBACK « Transaction « SQL / MySQL

1. SQL / MySQL
2. Transaction
3. TRANSACTION ROLLBACK

TRANSACTION and ROLLBACK

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 (3, 'Angels', 1966);
INSERT INTO Books VALUES (4, 'Black', 1932);
ROLLBACK;


select * from Books;


           
       

Related examples in the same category