Error Code: 1175. You are using safe update mode
来源:互联网 发布:caffe安装在windows上 编辑:程序博客网 时间:2024/04/29 09:17
如有转载,请注明出处:http://blog.csdn.net/embedded_sky
使用MySQL Workbench执行SQL语句报错,同样的SQL语句在命令行模式下却可以执行成功。
错误代码如下:
19:33:43delete from queuedetail where date_format(create_tm, '%Y%m%d') < date_format(date_sub(curdate(), interval 30 day),'%Y%m%d')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 Editor and reconnect.0.000 sec
google得到如下结论:
MySQL Workbench工具的安全设置中在批量update或delete时,where条件中的字段不是主键,则会提示错误。
解决方案如下:
- 打开Workbench的菜单[Edit]->[Preferences...]
- 切换到[SQL Editor]页面
- 把[Forbid UPDATE and DELETE statements without a WHERE clause (safe updates)]之前的对勾去掉
- 点击[OK]按钮
- 最后一步记得要重启一下Workbench,否则你仍然会得到这个错误提示。
将上图中的勾去掉,重启MySQL Workbech即可解决。
0 0
- 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 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
- 1175. You are using safe update mode
- 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
- mysql: Error Code: 1175. You are using safe update
- Error Code: 1175. You are using safe update
- Error Code: 1175. You are using safe update
- Error Code: 1175. You are using safe update...
- MYSQL Error Code: 1175 You are using safe update mode...解决方法
- 用1、2、2、3、4、5这六个数字,用java写一个main函数,打印出所有不同的排列,如:512234、412345等,要求:"4"不能在第三位,"3"与"5"不能相连。用1、2、2、3、4、5这六
- [原]CI环境下开发Oauth2.0开放平台
- C#设计模式学习笔记-单例模式
- 开始SDN
- 文件基本操作示例-文件读写
- Error Code: 1175. You are using safe update mode
- http://www.51zxw.net/study.asp?vip=11042319
- IOS开发笔记 - 基于SDWebImage的网络图片加载处理
- spark 安装和使用
- Scala函数、流程控制
- oracle运用(三) oracle数据库解锁
- Java NIO框架Netty教程(一) Hello Netty
- Java NIO框架Netty教程(二) 白话概念
- [BetterExplained]为什么你应该(从现在开始就)写博客