mysql修改数据报错Error Code: 1175. You are using safe update mode

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.

正在使用安全更新模式

mysql> show variables like 'sql_safe%';+------------------+-------+| Variable_name | Value |+------------------+-------+| sql_safe_updates | ON |+------------------+-------+

SQL_SAFE_UPDATES = 1，ON时开启安全更新模式

SQL_SAFE_UPDATES =0，OFF时关闭安全更新模式

关闭安全更新模式

mysql> set sql_safe_updates=0;

mysql> show variables like 'sql_safe%';+------------------+-------+| Variable_name | Value |+------------------+-------+| sql_safe_updates | OFF |+------------------+-------+

更改只在当前生效，退出mysql，再次登录后恢复为默认。