1
set binlog_format=statement;
3
create database testing_1;
5
create table t1 (a int);
6
create function sf1 (a int) returns int return a+1;
7
create trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a);
8
create procedure sp1 (a int) insert into t1 values(a);
9
drop database testing_1;
10
show binlog events from <binlog_start>;
11
Log_name Pos Event_type Server_id End_log_pos Info
12
master-bin.000001 # Query # # create database testing_1
13
master-bin.000001 # Query # # use `testing_1`; create table t1 (a int)
14
master-bin.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` FUNCTION `sf1`(a int) RETURNS int(11)
16
master-bin.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a)
17
master-bin.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `sp1`(a int)
18
insert into t1 values(a)
19
master-bin.000001 # Query # # drop database testing_1
22
create temporary table tt1 (a int);
23
create table t1 (a int);
24
insert into t1 values (1);
25
drop database if exists mysqltest1;
26
insert into t1 values (1);
28
show binlog events from <binlog_start>;
29
Log_name Pos Event_type Server_id End_log_pos Info
30
master-bin.000001 # Query # # use `test`; create temporary table tt1 (a int)
31
master-bin.000001 # Query # # use `test`; create table t1 (a int)
32
master-bin.000001 # Query # # use `test`; insert into t1 values (1)
33
master-bin.000001 # Query # # drop database if exists mysqltest1
34
master-bin.000001 # Query # # use `test`; insert into t1 values (1)
35
master-bin.000001 # Query # # use `test`; drop table tt1, t1
37
set binlog_format=mixed;
39
create database testing_1;
41
create table t1 (a int);
42
create function sf1 (a int) returns int return a+1;
43
create trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a);
44
create procedure sp1 (a int) insert into t1 values(a);
45
drop database testing_1;
46
show binlog events from <binlog_start>;
47
Log_name Pos Event_type Server_id End_log_pos Info
48
master-bin.000001 # Query # # create database testing_1
49
master-bin.000001 # Query # # use `testing_1`; create table t1 (a int)
50
master-bin.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` FUNCTION `sf1`(a int) RETURNS int(11)
52
master-bin.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a)
53
master-bin.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `sp1`(a int)
54
insert into t1 values(a)
55
master-bin.000001 # Query # # drop database testing_1
58
create temporary table tt1 (a int);
59
create table t1 (a int);
60
insert into t1 values (1);
61
drop database if exists mysqltest1;
62
insert into t1 values (1);
64
show binlog events from <binlog_start>;
65
Log_name Pos Event_type Server_id End_log_pos Info
66
master-bin.000001 # Query # # use `test`; create temporary table tt1 (a int)
67
master-bin.000001 # Query # # use `test`; create table t1 (a int)
68
master-bin.000001 # Query # # use `test`; insert into t1 values (1)
69
master-bin.000001 # Query # # drop database if exists mysqltest1
70
master-bin.000001 # Query # # use `test`; insert into t1 values (1)
71
master-bin.000001 # Query # # use `test`; drop table tt1, t1
73
set binlog_format=row;
75
create database testing_1;
77
create table t1 (a int);
78
create function sf1 (a int) returns int return a+1;
79
create trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a);
80
create procedure sp1 (a int) insert into t1 values(a);
81
drop database testing_1;
82
show binlog events from <binlog_start>;
83
Log_name Pos Event_type Server_id End_log_pos Info
84
master-bin.000001 # Query # # create database testing_1
85
master-bin.000001 # Query # # use `testing_1`; create table t1 (a int)
86
master-bin.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` FUNCTION `sf1`(a int) RETURNS int(11)
88
master-bin.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a)
89
master-bin.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `sp1`(a int)
90
insert into t1 values(a)
91
master-bin.000001 # Query # # drop database testing_1
94
create temporary table tt1 (a int);
95
create table t1 (a int);
96
insert into t1 values (1);
97
drop database if exists mysqltest1;
98
insert into t1 values (1);
100
show binlog events from <binlog_start>;
101
Log_name Pos Event_type Server_id End_log_pos Info
102
master-bin.000001 # Query # # use `test`; create table t1 (a int)
103
master-bin.000001 # Query # # BEGIN
104
master-bin.000001 # Table_map # # table_id: # (test.t1)
105
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
106
master-bin.000001 # Query # # COMMIT
107
master-bin.000001 # Query # # drop database if exists mysqltest1
108
master-bin.000001 # Query # # BEGIN
109
master-bin.000001 # Table_map # # table_id: # (test.t1)
110
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
111
master-bin.000001 # Query # # COMMIT
112
master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */