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
DROP TABLE IF EXISTS t1, t2;
8
DROP PROCEDURE IF EXISTS p1;
9
DROP PROCEDURE IF EXISTS p2;
10
DROP TRIGGER IF EXISTS tr1;
11
DROP FUNCTION IF EXISTS f1;
12
CREATE TABLE t1 (id INT AUTO_INCREMENT PRIMARY KEY);
13
CREATE TABLE t2 (id INT AUTO_INCREMENT PRIMARY KEY);
16
DECLARE ins_count INT DEFAULT 10;
17
WHILE ins_count > 0 DO
18
INSERT INTO t1 VALUES (NULL);
19
SET ins_count = ins_count - 1;
21
DELETE FROM t1 WHERE id = 1;
22
DELETE FROM t1 WHERE id = 2;
23
DELETE FROM t2 WHERE id = 1;
24
DELETE FROM t2 WHERE id = 2;
28
INSERT INTO t1 VALUES (NULL);
29
DELETE FROM t1 WHERE id = f1(3);
30
DELETE FROM t1 WHERE id = f1(4);
31
DELETE FROM t2 WHERE id = 3;
32
DELETE FROM t2 WHERE id = 4;
34
CREATE TRIGGER tr1 BEFORE DELETE
37
INSERT INTO t2 VALUES (NULL);
39
CREATE FUNCTION f1 (i int) RETURNS int
41
INSERT INTO t2 VALUES (NULL);
45
show binlog events from <binlog_start>;
46
Log_name Pos Event_type Server_id End_log_pos Info
47
master-bin.000001 # Intvar # # INSERT_ID=1
48
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (NULL)
49
master-bin.000001 # Intvar # # INSERT_ID=2
50
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (NULL)
51
master-bin.000001 # Intvar # # INSERT_ID=3
52
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (NULL)
53
master-bin.000001 # Intvar # # INSERT_ID=4
54
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (NULL)
55
master-bin.000001 # Intvar # # INSERT_ID=5
56
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (NULL)
57
master-bin.000001 # Intvar # # INSERT_ID=6
58
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (NULL)
59
master-bin.000001 # Intvar # # INSERT_ID=7
60
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (NULL)
61
master-bin.000001 # Intvar # # INSERT_ID=8
62
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (NULL)
63
master-bin.000001 # Intvar # # INSERT_ID=9
64
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (NULL)
65
master-bin.000001 # Intvar # # INSERT_ID=10
66
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (NULL)
67
master-bin.000001 # Intvar # # INSERT_ID=1
68
master-bin.000001 # Query # # use `test`; DELETE FROM t1 WHERE id = 1
69
master-bin.000001 # Intvar # # INSERT_ID=2
70
master-bin.000001 # Query # # use `test`; DELETE FROM t1 WHERE id = 2
71
master-bin.000001 # Query # # use `test`; DELETE FROM t2 WHERE id = 1
72
master-bin.000001 # Query # # use `test`; DELETE FROM t2 WHERE id = 2
101
show binlog events from <binlog_start>;
102
Log_name Pos Event_type Server_id End_log_pos Info
103
master-bin.000001 # Intvar # # INSERT_ID=11
104
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (NULL)
105
master-bin.000001 # Intvar # # INSERT_ID=3
106
master-bin.000001 # Query # # use `test`; DELETE FROM t1 WHERE id = f1(3)
107
master-bin.000001 # Intvar # # INSERT_ID=12
108
master-bin.000001 # Query # # use `test`; DELETE FROM t1 WHERE id = f1(4)
109
master-bin.000001 # Query # # use `test`; DELETE FROM t2 WHERE id = 3
110
master-bin.000001 # Query # # use `test`; DELETE FROM t2 WHERE id = 4
165
DROP TABLE IF EXISTS t1, t2;
166
DROP PROCEDURE IF EXISTS p1;
167
DROP PROCEDURE IF EXISTS p2;
168
DROP FUNCTION IF EXISTS f1;
169
DROP TRIGGER IF EXISTS tr1;