Просмотр исходного текста страницы SQL/MySQL/Transaction/TRANSACTION COMMIT

==Using TRANSACTION and COMMIT==



   
  <!-- start source code -->
   
    <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>