DROP TABLE IF EXISTS t1; RESET MASTER; CREATE TABLE t1 (a INT); SET AUTOCOMMIT=OFF; BEGIN; INSERT INTO t1 VALUES(1); DROP TABLE t1;; COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES(1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */