热线电话:13121318867

登录
2024-06-09 阅读量: 2066
sql 执行update修改字段报错

Hi 各位大神,

我的mysql执行字段修改时,报错信息如下

sql_update_err.rar

,麻烦帮忙看看原因,谢谢

18:05:54 update stu set s_sex='男' where s_sex='未知' 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.000 sec

详细错误信息见附件截图


0.0000
1
关注作者
收藏
评论(1)

发表评论
CDA持证人阿涛哥
1月前

CDA L1 mysql报错Error Code: 1175. You are using safe update mode

https://www.cda.cn/discuss/post/details/63a4110de1840060d6346421



0.0000 0 0 回复