1
drop table if exists t1;
3
create table t1 (a int);
4
prepare s from "insert into t1 values (@a),(?)";
7
prepare s from "insert into t1 values (?)";
10
prepare s from "insert into t1 select 100 limit ?";
14
Warning 1592 Statement is not safe to log in statement format.
15
show binlog events from <binlog_start>;
16
Log_name Pos Event_type Server_id End_log_pos Info
17
master-bin.000001 # Query # # use `test`; create table t1 (a int)
18
master-bin.000001 # User var # # @`a`=98
19
master-bin.000001 # Query # # use `test`; insert into t1 values (@a),(98)
20
master-bin.000001 # Query # # use `test`; insert into t1 values (99)
21
master-bin.000001 # Query # # use `test`; insert into t1 select 100 limit 100