2024-06-09
閱讀量:
5301
sql 執(zhí)行update修改字段報(bào)錯(cuò)
Hi 各位大神,
我的mysql執(zhí)行字段修改時(shí),報(bào)錯(cuò)信息如下
,麻煩幫忙看看原因,謝謝
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
詳細(xì)錯(cuò)誤信息見(jiàn)附件截圖






評(píng)論(1)


CDA持證人阿濤哥
2024-10-28
CDA L1 mysql報(bào)錯(cuò)Error Code: 1175. You are using safe update mode
http://www.3lll3.cn/discuss/post/details/63a4110de1840060d6346421
0.0000
0
0
CDA考試動(dòng)態(tài)
CDA報(bào)考指南
推薦帖子
0條評(píng)論
1條評(píng)論
0條評(píng)論