drop table if exists t1;reset master;create table t1 (a int);prepare s from "insert into t1 values (@a),(?)";set @a=98;execute s using @a;prepare s from "insert into t1 values (?)";set @a=99;execute s using @a;prepare s from "insert into t1 select 100 limit ?";set @a=100;execute s using @a;
Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statement uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
show binlog events from <binlog_start>;Log_name Pos Event_type Server_id End_log_pos Infomaster-bin.000001 # Query # # use `test`; create table t1 (a int)master-bin.000001 # User var # # @`a`=98master-bin.000001 # Query # # use `test`; insert into t1 values (@a),(98)master-bin.000001 # Query # # use `test`; insert into t1 values (99)