Mysql 5.7,默认执行 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.
原因:
默认的安全策略,使得更新时,如果不依靠主键列进行查询时将被提示并失败。
解决方式:
SET SQL_SAFE_UPDATES = 0;
关闭掉该方式
修改如下:
SET SQL_SAFE_UPDATES = 0;
UPDATE `column` SET `column` = 新值 WHERE 非主键列条件;
SET SQL_SAFE_UPDATES = 1;