You are using safe update mode and you tried to update a table without a WHERE that uses a KEY colum
来源:互联网 发布:易语言小软件 编辑:程序博客网 时间:2024/05/21 19:20
写在前面
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 Editor and reconnect. 0.000 sec
在执行 update 语句时 报错如上,根据上面的说明,我在对整个表格执行 update 语句,并且没有 where 对 某一列进行限制,mysql workbench安全模式不允许。
2.解决
上面也提示已了怎样解决这个问题, preferences–>SQL Editor 然后 reconnect.
首先 左上角 Edit –> preferences
然后在点击 SQL Editor ,翻到最下面 将勾去掉
Safe Updates(rejects UPDATES and DELETEs with no restrictores)
最后一定要重启,上面提示也说了,不然是不行的。
ps:重启后进来,不要先运行你的sql语句,先选择进入某一个数据库比如
use db1;
好吧 说这个的原因是我犯了这个错 hah
阅读全文
0 0
- You are using safe update mode and you tried to update a table without a WHERE that uses a KEY colum
- You are using safe update mode and you tried to update a table without a WHERE that uses a KEY colum
- You are using safe update mode and you tried to update a table without a WHERE that uses a KEY colum
- You are using safe update mode and you tried to update a table without a WHERE that uses a KEY colum
- You are using safe update mode and you tried to update a table without a WHERE that uses a KEY colum
- You are using safe update mode and you tried to update a table without a WHERE that uses a K
- MySQL错误:You are using safe update mode and you tried to update a table without a WHERE that uses
- MySQL错误:You are using safe update mode and you tried to update a table without a WHERE that uses a K
- MySQL错误:You are using safe update mode and you tried to update a table without a WHERE that uses a K
- MySQL错误:You are using safe update mode and you tried to update a table without a WHERE that uses a K
- MySQL错误:You are using safe update mode and you tried to update a table without a WHERE that uses a K
- MySQL错误:You are using safe update mode and you tried to update a table without a WHERE that uses a K
- 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 that
- Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that
- Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that
- Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that
- Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that
- 微信小程序三级联动(数据在我的资源里)
- css+div水平垂直居中布局总结(3种方案)
- 一些常用的小玩意之redis
- 用Thread类创建线程
- 协议、反向传值
- You are using safe update mode and you tried to update a table without a WHERE that uses a KEY colum
- 海思Hi35XX调试串口添加root登录密码
- apache+php+mysql常见集成环境安装包
- 【JavaScript学习】DOM:Document类型
- 钉钉服务端开发文档
- Mysql查询将列里面的值替换为别的值但是实际值不变
- python踩坑记录
- jQuery表格常用操作方法-增加,查询,删除,排序,移动,全选
- python easyUI