User transaction in table
|
|
|
/*
mysql> select * from Student;
+-----------+------------+
| StudentID | Name |
+-----------+------------+
| 1 | JJ Smith |
| 2 | Joe Yin |
| 3 | John Lee |
| 4 | Jacky Chen |
+-----------+------------+
4 rows in set (0.03 sec)
*/
Drop table Student;
CREATE TABLE Student (
StudentID INT NOT NULL PRIMARY KEY,
Name VARCHAR(50) NOT NULL
)TYPE = InnoDB;
INSERT INTO Student (StudentID,Name) VALUES (1,'JJ Smith');
INSERT INTO Student (StudentID,Name) VALUES (2,'Joe Yin');
INSERT INTO Student (StudentID,Name) VALUES (3,'John Lee');
INSERT INTO Student (StudentID,Name) VALUES (4,'Jacky Chen');
BEGIN;
INSERT INTO Student (StudentID, Name) VALUES (98, 'Anne');
INSERT INTO Student (StudentID, Name) VALUES (99, 'Julian');
ROLLBACK;
select * from Student;
|
|
|
|
|
|
|
