本文介绍了解决MySQL中遇到的ErrorCode:1175更新错误的方法。该错误通常发生在使用安全更新模式时尝试更新没有指定带有键的WHERE子句的表。解决方案为暂时关闭安全更新模式。
处理MySQL更新表时ErrorCode:1175.You are using safe update mode and you tried to update a table without a WHERE that uses a KEY
Error: 1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE)
Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
Solution：
SET SQL_SAFE_UPDATES = 0;
Error: 1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE)
Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
Solution：
SET SQL_SAFE_UPDATES = 0;
扫一扫
1186
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
