解决Mysql Workbench的Error Code: 1175错误

错误:

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. 0.00026 sec

分析:

使用workbench，如果你要批量更新或删除数据，一般会报“

Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column”错误，这是Workbench的安全设置导致的，通过设置就可以处理。

解决办法:

快速设置，直接在workbench里面的查询窗口输入“SET SQL_SAFE_UPDATES = 0；”就可以了

SET SQL_SAFE_UPDATES = 0;
update testcase set check_point = '"code":200'
where creater ="xxx";

SELECT * FROM test.testcase;

参考

https://jingyan.baidu.com/article/6c67b1d6f0efca2787bb1eba.html