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.

在修改一条数据字段时报错:

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

解决办法步骤:

1:先执行  show variables like 'SQL_SAFE_UPDATES';

2:再执行  SET SQL_SAFE_UPDATES = 0;

这就修改好,再执行要修改的sql语句就可以通过。

posted @ 2018-11-28 15:57  Iven_雨之恋  阅读(436)  评论(0编辑  收藏  举报