数据库 safe You are using safe update mode and you tried to update a table without a WHERE
来源:互联网 发布:淘宝客户关系管理软件 编辑:程序博客网 时间:2024/05/17 02:36
ou 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.
数据库safe保护,原来是msql workbench的安全设置。当进行批量删除或者更新的时候会发生
快速解决办法 执行 SET SQL_SAFE_UPDATES =0;
普通方法
1.打开workbench菜单(Edit)>[perferences]
2.切换到[sql editor]界面
3.把[forbid uppdate and delete statement without clause (safe updates)]之前的勾去掉(有的是safe update and ****反正这个勾去掉)
点击OK按钮
4.最后一部记得重启workbench,否则还是会报错。
1 0
- 数据库 safe You are using safe update mode and you tried to update a table without a WHERE
- 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 tha
- Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that
- MySQL错误:You are using safe update mode and you tried to update a table without a WHERE that uses
- 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 tha
- 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
- 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
- MySQL WorkbenchYou are using safe update mode and you tried to update a table without a WHERE that u
- 在数据库中执行删除delete语句时出现:You are using safe update mode and you tried to update a table without a WHERE
- mysql Error Code: 1175 You are using safe update mode and you tried to update a table without a W
- 11. Container With Most Water
- 关于一笔画问题的简单解答ACM中的题(1)
- iOS开发系列--音频播放、录音、视频播放、拍照、视频录制
- 56.EasyLikeArea
- 版本管理
- 数据库 safe You are using safe update mode and you tried to update a table without a WHERE
- canvas 制作时钟效果
- [LintCode] 用递归打印数字 Print Numbers by Recursion
- RabbitMQ (四) 路由选择 (Routing)
- Viewpager滑动菜单小记一下
- HttpURLConnection用法详解
- 风险管理
- 用例评审
- 学习h5第一天的心得