mysql 警告提示Unsafe statement .The statement is unsafe because it uses a LIMIT clause
来源:互联网 发布:内陆省份知乎 编辑:程序博客网 时间:2024/05/17 11:56
Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted。
执行sql语句
UPDATE tableName set value=v WHERE id='' LIMIT 10;
mysql 警告提示,为了消除该提示:
1、
修改binlog_format格式为mixed;
登陆mysql,执行 set global binlog_format=MIXED;
2、
修改sql语句
0 0
- mysql 警告提示Unsafe statement .The statement is unsafe because it uses a LIMIT clause
- Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. S
- Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.
- Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. S
- Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.
- Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.
- [Warning] Unsafe statement written to the binary log using statement format since 错误
- error code 1592 Unsafe statement written to the binary log using statement...
- 67.The instance abnormally terminates because of a power outage. Which statement is true about redo
- this program uses gets(), which is unsafe.
- this program uses gets(), which is unsafe.
- c中使用gets() 提示warning: this program uses gets(), which is unsafe.
- 不明警告:empty controlled statement found; is this the intent?
- The MySQL server is running with the --read-only option so it cannot execute this statement
- mysql中的select limit statement
- Sybase数据库提示The 'CREATE TABLE' command is not allowed within a multi-statement
- 68.Which statement is true regarding the default behavior of the ORDER BY clause?
- warning: this program uses gets(), which is unsafe.
- div左右分布
- 插件化开发—动态加载技术加载已安装和未安装的apk
- C#中的throw
- HDU 1312 Red and Black
- 图结构练习——最小生成树
- mysql 警告提示Unsafe statement .The statement is unsafe because it uses a LIMIT clause
- Spring MVC详解(四) Controller接口控制器详解(7 )完
- 算法导论2.3-5二分查找
- FIND_IN_SET 用法, 变量在字段值集合中是否包含
- Python的Crypto模块使用:自动输入Shell中的密码
- Eclipse常见问题解决 - The method getTextContent() is undefined for the type Node.
- SIP初步
- CentOS 6.3下Samba服务器的安装与配置
- Snail—UI学习之滑块UISlider