上二层楼
上二层楼
DB
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 recon
全部文章
DB
C++(32)
CG(8)
Design Pattern(3)
DS and Algorithm(4)
Git(2)
Interview(1)
Java raw(4)
leetcode-easy(27)
leetcode-midium(22)
little_tips(11)
Math Concern(4)
Math Modeling(3)
OS(6)
Project(1)
Python raw(5)
Web(2)
未归档(17)
题解(3)
归档
标签
去牛客网
登录
/
注册
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 recon
741 浏览
0 回复
2019-03-18
上二层楼
+关注
数据库默认模式是主键不可进行修改操作,所以需要运行以下语句。
SET SQL_SAFE_UPDATES = 0;
--
出现error1175使用。
举报
收藏
赞
评论加载中...