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 database if exists mysqltest;
8
create database mysqltest;
9
create table mysqltest.t1 ( n int);
10
insert into mysqltest.t1 values(1)/
11
insert into mysqltest.t1 values(2);
12
insert into mysqltest.t1 values(3);
13
insert into mysqltest.t1 values(4);
14
insert into mysqltest.t1 values(5)/
15
select * from mysqltest.t1;
22
show binlog events from <binlog_start>;
23
Log_name Pos Event_type Server_id End_log_pos Info
24
master-bin.000001 # Query # # drop database if exists mysqltest
25
master-bin.000001 # Query # # create database mysqltest
26
master-bin.000001 # Query # # use `test`; create table mysqltest.t1 ( n int)
27
master-bin.000001 # Query # # use `test`; insert into mysqltest.t1 values(1)
28
master-bin.000001 # Query # # use `test`; insert into mysqltest.t1 values(2)
29
master-bin.000001 # Query # # use `test`; insert into mysqltest.t1 values(3)
30
master-bin.000001 # Query # # use `test`; insert into mysqltest.t1 values(4)
31
master-bin.000001 # Query # # use `test`; insert into mysqltest.t1 values(5)
32
drop database mysqltest;