two method compared 1. use test; create table t (a int); 2. create table test.t1(a int);
my result is the first one can log the binlog but the second one can't not
use test;create table t(a int);
mysqlbinlog -v mysql-bin.000005|grep create
use `test`/*!*/;
SET TIMESTAMP=1490090893/*!*/;
create table t(a int)
/*!*/;
DELIMITER ;
but when I do not use "use", DML cannot log in binlog,can tell me why?
create table test.t(a int);
mysqlbinlog -v mysql-bin.000005|grep create test.t