[root@mariadb mysql]# mysql --version mysql Ver 14.14 Distrib 5.6.26, for linux-glibc2.5 (x86_64) using EditLine wrapper mysql> SELECT @@global.binlog_format, @@session.binlog_format; +------------------------+-------------------------+ | @@global.binlog_format | @@session.binlog_format | +------------------------+-------------------------+ | MIXED | MIXED | +------------------------+-------------------------+ 1 row in set (0.00 sec) mysql> create temporary table ptest1(i int); Query OK, 0 rows affected (0.01 sec) mysql> SELECT @@global.binlog_format, @@session.binlog_format; +------------------------+-------------------------+ | @@global.binlog_format | @@session.binlog_format | +------------------------+-------------------------+ | MIXED | MIXED | +------------------------+-------------------------+ 1 row in set (0.00 sec) mysql> select current_user(); +----------------+ | current_user() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.00 sec) mysql> create temporary table ptest2(i int); Query OK, 0 rows affected (0.00 sec) mysql> create index i on ptest2(i); Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> exit Bye [root@mariadb mysql]# mysqlbinlog -vv mysql-bin.000003 | grep ptest create temporary table ptest1(i int) DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `ptest2`,`ptest1`