mysql 更新数据报错Error Code: 1175. You are using safe update mode and you tried to update a table without

软件使用的是MYSQL workbench 8.0 CE

我想对数据进行更新

update boystudents  set memo = '三好生'  where stdid in (select stdid from studying group by stdid having avg(mark) > 80 ) ;

但是出现了错误

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.

 

 

解决方案：

这个问题的出现主要是，这个软件的安全权限太高了，把安全降级。

输入命令  SET SQL_SAFE_UPDATES = 0;

成功运行后就可以更新数据了。