ERROR 1665 (HY000)
【环境描述】
msyql5.6.14
【报错信息】
执行SQL语句的时候报错：
ERROR 1665 (HY000): Cannot executestatement: impossible to write to binary log since BINLOG_FORMAT = STATEMENTand at least one table uses a storage engine limited to row-based logging.InnoDB is limited to row-logging when transaction isolation level is READCOMMITTED or READ UNCOMMITTED.
【报错原因】
innodb的事务隔离级别是read commited或者read uncommited模式时，binlog不可以使用statement模式。
【解决方法】
不重启mysql实例的解决方法：
set global binlog_format=mixed
重新建立的会话session中binlog format会变为mixed模式。
您可能感兴趣的文章:mysql error 1130 hy000:Host''localhost''解决方案详解远程连接Mysql数据库的问题(ERROR 2003 (HY000))mysql错误处理之ERROR 1786 (HY000)MySQL错误ERROR 2002 (HY000): Can''t connect to local MySQL server through socketMySQL ERROR 2013 (HY000)错误解决方法mysql中一个普通ERROR 1135 (HY000)错误引发的血案PHP下使用mysqli的函数连接mysql出现warning: mysqli::real_connect(): (hy000/1040): ...