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

標籤：

今天用mysql workbench在更新資料的時候，出現了下面錯誤：
15:52:39    update wp_posts set post_content = replace(post_content, ‘/water‘, ‘‘)    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
解決辦法：在更新之前加上下面這句即可。
SET SQL_SAFE_UPDATES = 0;

或者按照提示在開啟菜單的Edit->Preferences，

在重啟mysql就行。

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