Using TRANSACTION and COMMIT : TRANSACTION COMMIT « Transaction « SQL / MySQL






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;

           
         
  








Related examples in the same category

1.Start a TRANSACTION