MySQL的安全模式
今天delete一条数据的时候,出现了以下错误.
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 Queries and reconnect.
因为MySql运行在safe-updates模式下.
想要解除该模式,运行以下命令:
SET SQL_SAFE_UPDATES = 0
为了安全,建议执行完操作后,再恢复成默认状态1
微信公众号
![](https://incomparable9527.coding.net/p/imageBed/d/imageBed/git/raw/master/c2a91cfb597826a4b02b755746c300e00cc7728a9f5bac20bec538e8c76a443f.png)