1
DROP TABLE IF EXISTS t1;
4
, padding VARCHAR(200) NOT NULL
7
INSERT INTO t1 VALUES (1, "I love testing.");
8
INSERT INTO t1 VALUES (2, "I hate testing.");
9
UPDATE t1 SET padding= "I REALLY love testing." WHERE id = 1;
10
UPDATE t1 SET padding= "I REALLY hate testing." WHERE id = 2;
12
/* SID: 1 XID: 0 */ DROP TABLE IF EXISTS t1;
14
/* SID: 1 XID: 0 */ CREATE TABLE t1 ( id INT NOT NULL , padding VARCHAR(200) NOT NULL , PRIMARY KEY (id) );
16
/* SID: 1 XID: 3 */ INSERT INTO `test`.`t1` (`id`, `padding`) VALUES ("1", "I love testing.");
18
/* SID: 1 XID: 4 */ INSERT INTO `test`.`t1` (`id`, `padding`) VALUES ("2", "I hate testing.");
20
/* SID: 1 XID: 5 */ UPDATE `test`.`t1` SET `padding` = "I REALLY love testing." WHERE `id` = "1"
22
/* SID: 1 XID: 6 */ UPDATE `test`.`t1` SET `padding` = "I REALLY hate testing." WHERE `id` = "2"