Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that
来源:互联网 发布:免费注册域名活动 编辑:程序博客网 时间:2024/05/16 15:24
快速高效用:SET SQL_SAFE_UPDATES = 0;下面的就不要看了!
今日用MySQL Workbench进行数据库的管理更新时,执行一个更新的语句碰到以下错误提示:
Error Code: 1175
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
进过一番搜索之后发现原来是MySQL Workbench的安全设置。当要执行的SQL语句是进行批量更新或者删除的时候就会提示这个错误。
解决方法如下:
- 打开Workbench的菜单[Edit]->[Preferences...]
- 切换到[SQL Editor]页面
- 把[Forbid UPDATE and DELETE statements without a WHERE clause (safe updates)]之前的对勾去掉
- 点击[OK]按钮
- 最后一步记得要重启一下Workbench,否则你仍然会得到这个错误提示。
如下图:
再次运行SQL语句就没问题了
link:http://blog.csdn.net/amohan/article/details/9980315
0 0
- 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
- 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 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
- 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 without a WHERE that uses a K
- mysql Error Code: 1175 You are using safe update mode and you tried to update a table without a W
- ErrorCode:1175.You are using safe update mode and you tried to update a table without a WHERE that u
- MySQL错误:You are using safe update mode and you tried to update a table without a WHERE that uses
- MySQL WorkbenchYou 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
- 数据库 safe You are using safe update mode and you tried to update a table without a WHERE
- 【Java线程】锁机制:synchronized、Lock、Condition
- Xcode编译因缺失包而引起的错误与相应库对照 [持续更新]
- 同步助手项目之封装Http帮助类
- 刚刚走进圈里的自我反省,持续更新。。。
- boost tcp 同步方式 笔记
- Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that
- 突破自己—电子工程师如何搞定VC++
- Flex学习笔记(四)——数据类型的操作(DataType)
- Mac终端打不开或显示 [进程已完成]解决办法
- UVA 10820 Send a Table euler_phi函数
- 利用opencv类库在MFC显示摄像头视频并且保存摄像头视频
- 关于Linux 分区
- ubuntu10.04 下面安装JDK1.6.30
- 张艺谋说高仓健:一位古代君子