1175. You are using safe update mode
来源:互联网 发布:淘宝店想改店铺名 编辑:程序博客网 时间:2024/04/30 17:26
update A,B set A.popularize=1 where A.brand_id=2 and B.app_id=A.app_id;
执行了上面的语句总是报如下错误,还以为是写错了,
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Queries and reconnect.
上网查了下才知道上网查了下才知道 原因是在safe mode下,要强制安全点,without a WHERE that uses a KEY column To disable safe mode
要取消这个限制,可以:
SET SQL_SAFE_UPDATES=0;
即可
0 0
- 1175. You are using safe update mode
- mysql You are using safe update mode
- Error Code: 1175. You are using safe update mode
- Error Code: 1175. You are using safe update mode
- Error Code: 1175. You are using safe update mode and you tried to update a table
- MySql报Error Code: 1175. You are using safe update mode and you tried to update...
- MySQL Error:You are using safe update mode and.....
- Mysql update error: Error Code: 1175. You are using safe update mode and you tried to update a table
- Mysql -update - Error Code: 1175. You are using safe update mode and you tried to update a table wit
- ErrorCode:1175.You are using safe update mode and you tried to update a table without a WHERE that u
- Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE tha
- Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE tha
- Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE
- Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE tha
- 如何解决MySQL Workbench中的错误Error Code: 1175. You are using safe update mode and you tried to update
- Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE tha
- You are using safe update mode and you tried to update a table……
- 数据库 safe You are using safe update mode and you tried to update a table without a WHERE
- C++ 标准模板库STL 队列 queue 使用方法与应用介绍(一)
- github.global.ssl.fastly.net hosts
- SQL SERVER创建和更新统计信息
- response.sendRedirect的使用
- 相机学习
- 1175. You are using safe update mode
- XP进军中国,Linux奋起反击
- mysql外键设置详解
- ubuntu下ATI/Intel双显卡切换的方法
- [置顶] 一个小马
- 第二十章,生与死的较量之回忆(下)
- 文件上传下载struts2
- http常见状态吗及说明
- java 环境变量设置