2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
set @old_global_binlog_format = @@global.binlog_format;
8
set @@global.binlog_format = row;
9
CREATE SCHEMA IF NOT EXISTS mysqlslap;
11
select @@global.binlog_format;
12
@@global.binlog_format
14
CREATE TABLE t1 (id INT primary key auto_increment, name VARCHAR(64));
16
SELECT COUNT(*) FROM t1;
20
SELECT COUNT(*) FROM t1;
24
insert delayed into t1 values(10, "my name");
25
insert delayed into t1 values(10, "is Bond"), (20, "James Bond");
35
delete from t1 where id!=10;
36
insert delayed into t1 values(20, "is Bond"), (10, "James Bond");
47
DROP SCHEMA mysqlslap;
49
CREATE TABLE t1(a int, UNIQUE(a));
50
INSERT DELAYED IGNORE INTO t1 VALUES(1);
51
INSERT DELAYED IGNORE INTO t1 VALUES(1);
62
set @@global.binlog_format = @old_global_binlog_format;