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= "XXX" WHERE id= 1;
10
UPDATE t1 SET padding= "AAA";
13
id int AUTO_INCREMENT NOT NULL PRIMARY KEY
17
INSERT INTO t1 (name,alias) VALUES ("jeff lebowski","dude");
18
UPDATE t1 SET alias = "the dude" WHERE alias = "dude";
22
, counter INT NOT NULL
25
INSERT INTO t1 (id, counter) VALUES (1,1),(2,2),(3,3);
26
UPDATE t1 SET counter = counter + 1 WHERE id = 1;
27
UPDATE t1 SET counter = counter + 1 WHERE id IN (2,3);
31
, padding VARCHAR(200) NOT NULL
34
INSERT INTO t1 VALUES (1, "I love testing.");
35
INSERT INTO t1 VALUES (2, "I hate testing.");
36
UPDATE t1 SET id = 4 WHERE id = 2;
39
DROP TABLE IF EXISTS `test`.`t1`;
42
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
45
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
48
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
51
UPDATE `test`.`t1` SET `padding`='XXX' WHERE `id`=1;
54
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `id`=1;
55
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `id`=2;
58
DROP TABLE `test`.`t1`;
61
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL, `alias` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
64
INSERT INTO `test`.`t1` (`id`,`name`,`alias`) VALUES (1,'jeff lebowski','dude');
67
UPDATE `test`.`t1` SET `alias`='the dude' WHERE `id`=1;
70
DROP TABLE `test`.`t1`;
73
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `counter` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
76
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (1,1);
77
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (2,2);
78
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (3,3);
81
UPDATE `test`.`t1` SET `counter`=2 WHERE `id`=1;
84
UPDATE `test`.`t1` SET `counter`=3 WHERE `id`=2;
85
UPDATE `test`.`t1` SET `counter`=4 WHERE `id`=3;
88
DROP TABLE `test`.`t1`;
91
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
94
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
97
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
100
UPDATE `test`.`t1` SET `id`=4 WHERE `id`=2;
103
DROP TABLE `test`.`t1`;
106
Generating statements for innodb replication log
108
DROP TABLE IF EXISTS `test`.`t1`;
111
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
114
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
117
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
120
UPDATE `test`.`t1` SET `padding`='XXX' WHERE `id`=1;
123
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `id`=1;
124
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `id`=2;
127
DROP TABLE `test`.`t1`;
130
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL, `alias` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
133
INSERT INTO `test`.`t1` (`id`,`name`,`alias`) VALUES (1,'jeff lebowski','dude');
136
UPDATE `test`.`t1` SET `alias`='the dude' WHERE `id`=1;
139
DROP TABLE `test`.`t1`;
142
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `counter` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
145
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (1,1);
146
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (2,2);
147
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (3,3);
150
UPDATE `test`.`t1` SET `counter`=2 WHERE `id`=1;
153
UPDATE `test`.`t1` SET `counter`=3 WHERE `id`=2;
154
UPDATE `test`.`t1` SET `counter`=4 WHERE `id`=3;
157
DROP TABLE `test`.`t1`;
160
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
163
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
166
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
169
UPDATE `test`.`t1` SET `id`=4 WHERE `id`=2;
172
DROP TABLE `test`.`t1`;
174
SET GLOBAL transaction_log_truncate_debug= true;