1RESET MASTER; 2CREATE TABLE t1(a INT) ENGINE=InnoDB; 3CREATE TABLE t2(a INT) ENGINE=MyISAM; 4SET @saved_binlog_format= @@SESSION.binlog_format; 5SET SESSION binlog_format= 'STATEMENT'; 6CREATE TEMPORARY TABLE tmp10 (a INT); 7SET SESSION binlog_format= @saved_binlog_format; 8CREATE TEMPORARY TABLE tmp1 ENGINE=InnoDB SELECT * FROM t1; 9CREATE TEMPORARY TABLE tmp2 ENGINE=MyISAM SELECT * FROM t2; 10CREATE TEMPORARY TABLE tmp3 ENGINE=MyISAM SELECT * FROM t1; 11CREATE TEMPORARY TABLE tmp4 ENGINE=InnoDB SELECT * FROM t2; 12CREATE TEMPORARY TABLE tmp5 (a INT) ENGINE=InnoDB; 13CREATE TEMPORARY TABLE tmp6 (a INT) ENGINE=MyISAM; 14CREATE TEMPORARY TABLE tmp7 LIKE t1; 15CREATE TEMPORARY TABLE tmp8 LIKE t2; 16include/show_binlog_events.inc 17Log_name Pos Event_type Server_id End_log_pos Info 18master-bin.000001 # Query # # use `test`; CREATE TABLE t1(a INT) ENGINE=InnoDB 19master-bin.000001 # Query # # use `test`; CREATE TABLE t2(a INT) ENGINE=MyISAM 20master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tmp10 (a INT) 21master-bin.000001 # Query # # use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp10` 22DROP TABLE t1, t2; 23