mysql 警告提示Unsafe statement .The statement is unsafe because it uses a LIMIT clause

Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted。

执行sql语句

UPDATE tableName set value=v WHERE id='' LIMIT 10;

mysql 警告提示，为了消除该提示：

1、

修改binlog_format格式为mixed；

登陆mysql，执行 set global binlog_format=MIXED;

2、

修改sql语句