`
cocos
  • 浏览: 401816 次
  • 性别: Icon_minigender_1
  • 来自: 福州
社区版块
存档分类
最新评论

110613 22:17:52 [Warning] Statement may not be safe to log in statement format.

阅读更多
110613 22:17:52 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO ol_answerlog_6 (UserId,QuestionId,IsCorrect,AnswerXML,CostTime,Subject) VALUES (902183,'24206451-5105-42ac-a708-6b881a271f97',0,'<as><a><i><![CDATA[B]]></i></a></as>',10,10)
处理:
binlog_format的设置是不是STATEMENT?改成MIXED应该就没有警告.

可以不重启来更改binlog_format:

mysql>set global binlog_format=mixed;(root权限)
在[mysqld]下面加入下面这行
binlog_format=mixed



分享到:
评论

相关推荐

    EurekaLog_7.5.0.0_Enterprise

    23)..Fixed: NT service may not log all exceptions 24)..Fixed: SSL port number for Bugzilla 25)..Fixed: Disabling "Activate Exception Filters" option was ignored 26)..Fixed: Missing FTP proxy settings ...

    MySQL:Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEM

    150602 14:40:02 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT… SELECT… ON DUPLICATE KEY UPDATE is unsafe because the order in ...

    keil常见错误.pdf

    keil常见错误 main.c(35): warning: #128-D: ...initSpi.c(6): error: #268: declaration may not appear after executable statement in block main.c(31): warning: #223-D: function "initNvic" declared implicitly

    170: Warning: (1681, ‘Integer display width is deprecated and will be removed in a future release.’)

    在Python的数据库操作中,尤其是当你使用pymysql库连接MySQL数据库时,可能会遇到一个警告,提示"Integer display width is deprecated and will be removed in a future release." 这个警告源于MySQL数据库的一个...

    Quartus常见错误分析.doc

    Warning: VHDL Process Statement warning at ledmux.vhd(15): signal or variable "dataout" may not be assigned a new value in every possible path through the Process Statement. 解决方法:检查process语句...

    Laravel访问出错提示:`Warning: require(/vendor/autoload.php): failed to open stream: No such file or di解决方法

    本文实例讲述了Laravel框架访问...`Warning: require(/http/www.mywakavLee.cn/bootstrap/../vendor/autoload.php): failed to open stream: No such file or directory in /http/www.mywakavLee.cn/bootstrap/autolo

    新牛津高中英语模块二第三单元知识点整理及单元练习(含答案).pdf

    1. In 1891, at the age of 17, ...(在1891年,17岁时...) 以上是本单元的重点词汇和短语,学习这些内容能够帮助学生增强对英语的运用能力,提高阅读、写作和口语表达的水平。同时,理解和掌握这些句型对于构建...

    warning ..\package.json: No license field

    在初始化Vue项目的的时候发现警告 yarn install 查了下发现是,package.json 文件中缺少license参数 { name: movie_view, version: 0.1.0, license: MIT, private: true, ... serve: vue-cli-service serve, ...

    jackson-dataformat-smile-2.8.10-API文档-中文版.zip

    赠送jar包:jackson-dataformat-smile-2.8.10.jar; 赠送原API文档:jackson-dataformat-smile-2.8.10-javadoc.jar; 赠送源代码:jackson-dataformat-smile-2.8.10-sources.jar; 赠送Maven依赖信息文件:jackson-...

    file'psfig.sty' not found

    在LaTeX排版系统中,"file 'psfig.sty' not found" 是一个常见的错误信息,这通常意味着系统在编译文档时无法找到`psfig.sty`这个宏包文件。`psfig`宏包是LaTeX早期用于插入PostScript图形的工具,它允许用户在文档...

    itext-2.1.7.js7.jar

    Error POM for ...This is the bit that causes issues: ...&lt;artifactId&gt;itext &lt;version&gt;2.1.7.js7 &lt;scope&gt;compile &lt;optional&gt;false &lt;groupId&gt;org.bouncycastle &lt;artifactId&gt;bcmail-jdk15on ...&lt;/dependency&gt;

    大学英语三级词汇表.doc

    1. A.D.: An abbreviation for "Anno Domini," meaning "in the year of our Lord" in Latin, typically used to denote years in the Christian calendar. 2. A.M.: Stands for "Ante Meridiem," Latin for ...

    grafanarel.s3.amazonaws.com-grafana-2.6.0-linux64.tgz

    Could not find artifact org.apache.phoenix:phoenix-core:jar:4.4.0.2.3.4.0-3347,或者hbase、grafana、hadoop 和官方的其实是一样的,放心下载, 原名称是grafana-2.6.0.linux-x64.tar.gz,改下包名即可

    BURNINTEST--硬件检测工具

    entry will be added to the normal BurnInTest log. - Changes to trace logging to reduce activity when trace logging is not turned on. - Note: We have seen a report of the Video Playback failing ...

    keil错误集V1.0.pdf

    3. **错误#268: declaration may not appear after executable statement in block** 这个错误表明在执行语句(如函数调用、赋值等)之后尝试声明变量。在C语言中,变量声明必须位于代码块的开头。解决方法是将...

    001-glib-gdate-suppress-string-format-literal-warning.patch

    001-glib-gdate-suppress-string-format-literal-warning.patch 001-glib-gdate-suppress-string-format-literal-warning.patch 001-glib-gdate-suppress-string-format-literal-warning.patch

    php报时区错误,按照网上说的改时间date.timezone根本不管用!怎么解决,看我的.zip

    Warning: phpinfo() [function.phpinfo]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In ...

    yaffs_vfs.c, android

    s/yaffs2/yaffs_vfs.c: In function 'yaffs_read_super': fs/yaffs2/yaffs_vfs.c:2383:2: error: implicit declaration of function 'get_sb_bdev' fs/yaffs2/yaffs_vfs.c: At top level: fs/yaffs2/yaffs_vfs.c:...

    mysql could not be resolved: Name or service not known

    1.120119 16:26:04 [Warning] IP address ‘192.168.1.10’ could not be resolved: Name or service not known 2.120119 16:26:04 [Warning] IP address ‘192.168.1.14’ could not be resolved: Name or service ...

Global site tag (gtag.js) - Google Analytics