MySQL使用过程中遇到的小问题（积累篇）

问题一：Caused by: java.sql.BatchUpdateException: 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.

    首先了解一下：     

     #查看事务隔离级别   select @@tx_isolation;
     #查看binlog方式       select @@binlog_format;

    #设置session级别的BINLOG   SET SESSION binlog_format = 'MIXED' ;

    #设置系统级别的binlog        SET GLOBAL binlog_format = 'ROW';

       查看mysqld的binlog方式设置成最下面两行语句，或者到mysql的配置文件中将binlog_format=mixed前边的#去掉。然后重启     mySQL服务。