MYSQL出現Unsafe statement written to the binary log

Unsafe statement written to the binary log using statement format since BINLOG_FORMAT

影響列數:  1
Note: #1592 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.

 

這是BINGLOG設定的問題,

可以更換MYSQL BINGLOG設定:

set global binlog_format=MIXED;

 

 

PHP5網管實驗室 Jacch 2002-2016