MySql报错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.

Winter · 06月16日

MySql执行Update语句报错了

10:10:35	update tb_feature set title='JavaScript' where title like "%javascript%"	
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.066 sec
回答(1)
时间
W
Winter
1 · 2020-06-16 10:20:45

这个问题有两个处理方式:

  1. 先执行下面语句后再去执行你的sql
SET SQL_SAFE_UPDATES = 0;

2. 打开Workbench的菜单[Edit]->[Preferences...]切换到[SQL Editor]页面把[Forbid UPDATE and DELETE statements without a WHERE clause (safe updates)]之前的对勾去掉点击[OK]按钮最后一步记得要重启一下Workbench,否则你仍然会得到这个错误提示

你的回答

加载中...
⌘+Return 发表
发表

温馨提示:登录后可发表评论或回复

关闭,朕知道了

扫码关注微信公众号或小程序