如何解决MySQL Workbench中的错误Error Code: 1175. You are using safe update mode and you tried to update

错误描述

Win7电脑上新安装了 MySQL Workbench 6.3。打开后执行一条update语句，总是提示如下错误：

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.
————————————————

解决方法
错误提示中提到一句“To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.”我安装这句英文提示在菜单中找了一下，发现如下的解决方法：

菜单项Edit → Preferences → 选中左侧SQL Editor → 取消复选框 “Safe Updates” Forbid UPDATEs and DELETEs with no key in WHERE clause or no LIMIT clause. Requires a reconnection

修改后的界面如下：

 

 重启 MySQL Workbench 即可。

————————————————