降低mysql事务隔离级别

　　然而，报错了

java.sql.SQLException: 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.

　　于是看了下BINLOG_FORMAT ： 

　　于是：

　　这样就可以了，或者据说换MIXED模式也可以，不过没测试。

降低mysql事务隔离级别

标签：