解决WorkBench执行更新语句时【1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE)】
来源:互联网 发布:网络直播打赏 编辑:程序博客网 时间:2024/06/09 20:15
Error: 1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE)
Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
通常在之行Update语句时出现该问题,在前面加入:SET SQL_SAFE_UPDATES = 0;
近日在WorkBench下执行时发现可以通过设置[Edit]->[Preferences]->[SQL Editor]下,将
“Safe Updates”.Forbid Updates and Deletes with no key in Where clause or no Limit clause.Requires a reconnection.
前面的checkbox取消选中,保存即可~
注:workbench设置完后需要重新启动一下。
0 0
- 解决WorkBench执行更新语句时【1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE)】
- 解决Zend_Db SQLSTATE[HY000] [2002] Invalid argument
- 解决 drush PDOException: SQLSTATE[HY000] [2002]
- MySQL Workbench 执行更新或删除操作时出现 1175错误 安全更新限制
- SQLSTATE[HY000]: General error
- php artisan migrate时,[PDOException] SQLSTATE[HY000] [2002] No su
- SQL Error: 170, SQLState: HY000
- SQL Error: 1366, SQLState: HY000
- SQL Error: 1364, SQLState: HY000
- SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded 解决思路
- PDO连接MYSQL时出现:PDOException SQLSTATE[HY000] MySQL server has gone away
- laravel migrate 时出现错误 [PDOException] SQLSTATE[HY000]: General error: 1215 Cannot add foreign key
- Zend_Db SQLSTATE[HY000] [2002] Invalid argument
- Laravel [PDOException] SQLSTATE[HY000] [2002] Connection refused
- SQLSTATE[HY000] [1130] Host '127.0.0.1' is not allowed to connect to this MySQL server怎么解决?
- 拼SQL语句执行更新
- hibernate执行sql语句更新
- 腾讯云安装配置Apache+MariaDB服务器并解决SQLSTATE[HY000] [1130] Host t '*’ is not allowed to connect to this se问题
- ofbiz myeclipse 配
- 在Chrome调试JavaScript代码以及审查元素各个tab说明
- ofbiz 购物样式 ecommain.css
- Secure Delivery Center的许可证管理
- Step into Kotlin - 18 - Extension 与 this
- 解决WorkBench执行更新语句时【1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE)】
- 从零开始搭建hadoop分布式集群环境:(二)安装JDK
- 03-树3. Tree Traversals Again (25)
- 程序员的能力拓展模型
- product_store_shipment_meth
- 仿Google分页的经典案例
- POJ Gold Balanced Lineup
- 努力和上进不是为了做给别人看,而是为了不辜负自己
- iOS原生二维码扫描(可以指定有效区域)