MySQL Workbench批量修改数据报错:Error Code: 1175. You are using safe update mode and you tried to update a t
批量修改数据SQL:update sys_menu set menu_extralink = true
错误信息:
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.016 sec
解决办法:
Edit->Preferences->SQL-Editor->去掉Safe-Updates选项前的对勾
如下图所示: