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,再次登录后恢复为默认。