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

Ajax
Ajax Examples Ajax Tutorials Scripts and Programs
Javascript
Javascript Examples Tutorials DHTML Tutorials Javascript References Scripts and Programs
HTML
HTML Tutorials HTML References HTML DOM 0 References HTML DOM 2 References
CSS
CSS Tutorials CSS References
PHP
PHP Source Code PHP References Scripts and Programs
C#
C# Source Code C# Examples

SQL / MySQL » Transaction » TRANSACTION COMMIT »

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;