1DROP TABLE IF EXISTS t1; 2RESET MASTER; 3CREATE TABLE t1 (a INT); 4SET AUTOCOMMIT=OFF; 5BEGIN; 6INSERT INTO t1 VALUES(1); 7DROP TABLE t1;; 8COMMIT; 9include/show_binlog_events.inc 10Log_name Pos Event_type Server_id End_log_pos Info 11master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) 12master-bin.000001 # Query # # BEGIN 13master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES(1) 14master-bin.000001 # Query # # COMMIT 15master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ 16