TRANSACTION and save point : TRANSACTION ROLLBACK : Transaction SQL / MySQL


SQL / MySQL » Transaction » TRANSACTION ROLLBACK »

 

TRANSACTION and save point




Drop table Books;


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

select from Books;

START TRANSACTION;
INSERT INTO Books VALUES (3'Angels', 1966);
INSERT INTO Books VALUES (4'Black', 1932);
SAVEPOINT sp1;

select from Books;


           
       



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

SQL / MySQL

 Navioo Transaction
» TRANSACTION ROLLBACK