Error Code: 1175. You are using safe update mode and you tried to ......

MySQL提示的错误信息：

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

意思是：在安全更新模式下尝试使用未带关键字的“WHERE”语句，在Preference中切换该选项。

SET SQL_SAFE_UPDATES = 0; #关闭安全模式

SET SQL_SAFE_UPDATES = 1; #开启安全模式