1
DROP TABLE IF EXISTS t1;
3
CREATE TABLE t1 (a INT);
6
INSERT INTO t1 VALUES(1);
9
show binlog events from <binlog_start>;
10
Log_name Pos Event_type Server_id End_log_pos Info
11
master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
12
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES(1)
13
master-bin.000001 # Query # # use `test`; DROP TABLE t1