в 13:46, 26 мая 2010

2010-05-26T13:46:00Z

Admin: 1 версия

2010-05-26T10:16:39Z

1 версия

Новая страница

==User transaction in table==



<source lang="sql">
/*
mysql> select * from Student;
+-----------+------------+
| StudentID | Name |
+-----------+------------+
| 1 | JJ Smith |
| 2 | Joe Wang |
| 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 Wang");
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;

</source>

← Предыдущая	Версия 13:46, 26 мая 2010
(нет различий)

SQL/MySQL/Transaction/RollBack - История изменений

в 13:46, 26 мая 2010

Admin: 1 версия