MySql解除安全模式：Error Code: 1175. You are using safe update mode and you tried to update a table without...

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

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语句就可以通过。

转载于:https://www.cnblogs.com/Iven-zhang/p/10032619.html