MySQL更新提示You are using safe update mode

更新或删除数据时提示如下错误

17:37:38    delete from tb_crawl_ip 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.0051 sec

将sql_safe_updates关闭即可操作了

-- 1:on 0:off
SET SQL_SAFE_UPDATES = 1;
show variables like 'sql_safe%';

文章永久链接：https://tech.souyunku.com/43367