MySQL 安全错误

/MySQL错误代码：MySQL Workbench中UPDATE期间的1175错误代码/
/*解决方法 01 */

    SET SQL_SAFE_UPDATES=0;
    UPDATE tablename SET columnname=1;
    SET SQL_SAFE_UPDATES=1; 

/*解决方法 02 */
Follow the following steps before executing the UPDATE command: In MySQL Workbench 在执行UPDATE命令之前，请执行以下步骤： 在MySQL Workbench中

1. Go to Edit --> Preferences 转到Edit - > Preferences
2. Click “SQL Editor” tab and uncheck “Safe Updates” check box 单击"SQL Editor"选项卡， uncheck “安全更新” check box
3. Query --> Reconnect to Server // logout and then login Query - > Reconnect to Server //注销然后登录
4. Now execute your SQL query 现在执行SQL查询

ps, No need to restart the MySQL daemon! ps，无需重启MySQL守护进程！