Adminer always adds "LIMIT 1" to DELETE or UPDATE statements. We run a Master/Slave-SQL-Replication. The LIMIT 1 leads to this warning:
130509 22:30:57 [Warning] 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. Statement: UPDATE `plots` SET `MINSTATUSREQUIRED` = '200' WHERE `ID` = '293' COLLATE utf8_bin AND `STATION` = '105' LIMIT 1
LIMIT 1 doesn't make sense in this kind of statements. Can it be removed?
Log in to post a comment.