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.

Winter2020-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

Winter2020/06/16 10:20:45

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

先执行下面语句后再去执行你的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，否则你仍然会得到这个错误提示

Newest Answer

HTML5 Drag & Drop 拖动时更改图标/光标

5 Answer

如何完全卸载 Node.js，然后从头重新安装 (Mac OS X)

NUXT引入tailwindcss报错Error: Expected an opening square bracket.

1 Answer