2
CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY);
4
UPDATE t1 SET id = 2 WHERE id != 2 LIMIT 0;
7
CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY);
9
INSERT INTO t1 VALUES (1);
11
INSERT INTO t1 VALUES (2);
13
INSERT INTO t1 VALUES (3);
21
INSERT INTO t1 VALUES (4);
23
INSERT INTO t1 VALUES (5);
25
INSERT INTO t1 VALUES (6);
33
INSERT INTO t1 VALUES (4);
35
INSERT INTO t1 VALUES (5);
37
INSERT INTO t1 VALUES (6);
38
ROLLBACK TO SAVEPOINT A;