MySQL 错误. You are using safe update mode and you tried to update a table without ....

在执行delete语句的时候,可能会提示MySQL在保护模式, 无法进行删除, 错误如下

ErrorCode: 1175. You are using safe update mode and you tried to update a tablewithout a WHERE that uses a KEY column To disable safe mode, toggle the optionin Preferences -> SQL Editor and reconnect.

可以通过以下SQL进行状态查询

showvariables like 'sql_safe%';

解决方案:

执行SQL:
    set sql_safe_updates=0;
    或
    set sql_safe_updates=off;