Mysql报错：Eror Code: 1175.You are using safe update mode and you tried to update a table without

Eror 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运行在safe-updates模式下，该模式会导致非主键条件下无法执行update或者delete命令。
可以通过以下SQL进行状态查询：

show variables like 'SQL_SAFE_UPDATES';

• 执行下面的sql，关闭safe-updates模式：

SET SQL_SAFE_UPDATES = 0;

或

SET SQL_SAFE_UPDATES = false;

• 执行下面的sql，打开safe-updates模式：

SET SQL_SAFE_UPDATES = 1;

或

SET SQL_SAFE_UPDATES = true;