MySQL 在执行update、delete操作时,提示以下报错信息:
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.000 sec
检查发现safe Updates模式开启,可以在edit-Preferences-SQL Editor页面下取消勾选(如下图),还可以直接执行脚本
SET SQL_SAFE_UPDATES = 0关闭。