Categories: MySQLMySQL 5.7MySQL WorkbenchMySQL Workbench 8phpMyAdminphpMyAdmin 4.8数据库数据库管理工具

在 MySQL Workbench 中执行 UPDATE 语句，报错：Error Code: 1175 的分析解决

图1

1、在 MySQL Workbench 中执行 UPDATE 语句，语句如下：

UPDATE `cpa_channel_app_source` SET `group_id` = '015ce30b116ce86058fa6ab4fea4ac63' WHERE (`group_id` = 'spider');

2、报错：Error Code: 1175，具体报错信息如下：，如图1

图1

UPDATE `cpa_channel_app_source` SET `group_id` = '015ce30b116ce86058fa6ab4fea4ac63' WHERE (`group_id` = 'spider')
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.

3、在 phpMyAdmin 中执行 UPDATE 语句，语句如下：执行成功，如图2

图2

UPDATE `cpa_channel_app_source` SET `group_id` = '015ce30b116ce86058fa6ab4fea4ac63' WHERE (`group_id` = 'spider');

4、根据提示，要禁用安全模式，请在首选项 – >SQL编辑器中切换选项并重新连接。取消勾选安全更新选项，如图3

图3

Safe Updates (rejects UPDATEs and DELETEs with no restrictions)

5、关闭连接后，重新连接，执行 UPDATE 语句，语句如下：执行成功，如图4

图4

UPDATE `cpa_channel_app_source` SET `group_id` = '015ce30b116ce86058fa6ab4fea4ac63' WHERE (`group_id` = 'spider');

UPDATE `cpa_channel_app_source` SET `group_id` = '015ce30b116ce86058fa6ab4fea4ac63' WHERE (`group_id` = 'spider')
1 row(s) affected Rows matched: 1  Changed: 1  Warnings: 0

永夜