更新mysql出错:出错原因 You are using safe update mode
来源:互联网 发布:《大数据时代》好句 编辑:程序博客网 时间:2024/05/23 19:30
出错原因:Error Code: 1175
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column。
经过翻译是当前模式为安全更新模式,不能使用非主键列更新数据表。
解决方法:将数据库安全模式修改字段修改为1。
语句:SET SQL_SAFE_UPDATES=0;
注意:SQL_SAFE_UPDATES与=,以及=与0之间不能用空格。否则会更新出错。
修改完成后,可以使用非主键更新数据表了。
阅读全文
0 0
- 更新mysql出错:出错原因 You are using safe update mode
- mysql You are using safe update mode
- Mysql删除或者更新出错 Error Code: 1175. You are using safe update
- Mysql删除或者更新出错 Error Code: 1175. You are using safe update
- MySQL Error:You are using safe update mode and.....
- 1175. You are using safe update mode
- mysql 更新sql脚本: you are using safe update mode and you tried to update a table
- MySql报Error Code: 1175. You are using safe update mode and you tried to update...
- 处理MySQL更新表时Error Code: 1175. You are using safe update mode and you tried to update a table……
- 处理MySQL更新表时Error Code: 1175. You are using safe update mode and you tried to update a table……
- 关于MySQL执行更新操作时的 You are using safe update mode and you tried to update a table without
- Error Code: 1175. You are using safe update mode
- Error Code: 1175. You are using safe update mode
- Mysql update error: Error Code: 1175. You are using safe update mode and you tried to update a table
- Mysql -update - Error Code: 1175. You are using safe update mode and you tried to update a table wit
- MYSQL Error Code: 1175 You are using safe update mode...解决方法
- MySQL错误:You are using safe update mode and you tried to update a table without a WHERE that uses
- mysql解决ERROR Code 1175 : You are using safe update mode and you tried to update a tab
- XCTool介绍
- 物理standby database的日常维护
- latex for mac(Texworks)的使用入门
- 单链表插入排序
- 箭头函数的作用域
- 更新mysql出错:出错原因 You are using safe update mode
- StringMVC和myBatis框架整合
- 异常处理
- 矩阵连乘问题——动态规划求解(待续)
- 十九个国内外主流的三维GIS软件
- 资深大牛java
- 【1021】奖金分配:分段计算毛利的方法
- Programming Ability Test 乙级真题及训练集1004
- 171204—对char型数据输入问题的解决