本文介绍了一种常见的MySQL错误：当BINLOG_FORMAT设置为STATEMENT且使用了仅支持行级记录的存储引擎（如InnoDB）时，无法执行某些语句。文章提供了修改my.cnf配置文件中binlog格式为mixed模式的方法来解决这一问题。
mysql> insert emp values ('sss',null,null,null);
ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
mysql>
把my.cnf中binlog格式改为混合模式：
# binary logging format - mixed recommended
binlog_format=mixed
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
