Column 'id' in where clause is ambiguous
来源:互联网 发布:手机社区源码 编辑:程序博客网 时间:2024/06/05 17:20
该错误在mybatis中还是比较常见的。
1> clause :意思是条款,分句
2> ambiguous:意思为模棱两可
整体意思,就是id字段在分句中模棱两可,说明在表关联的时候,多个表均有此字段,因此不知道该查哪一个
所以只要加上表别名,区分开你要查那个表里的id字段,就ok了。
0 0
- Column 'id' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'Email' in where clause is ambiguous
- Column 'is_valid' in where clause is ambiguous
- Column ' ' in where clause is ambiguous
- column 'typeid' in where clause is ambiguous
- column in where clause is ambiguous MySQL异常
- 数据库异常:“Column 'CODE' in where clause is ambiguous”
- mysql Column 'dbvalue' in where clause is ambiguous解决方案
- 错误信息:Column 'SalesMarketID' in where clause is ambiguous
- mysql Error:1052 Column 'xxx' in where clause is ambiguous
- 错误代码: 1052 Column 'sys_date' in where clause is ambiguous
- where clause is ambiguous
- Integrity constraint violation: 1052 Column "order_id" in where clause is ambiguous
- Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous
- MyBatis拦截器实现分页功能
- Android 上下滚动条、轮训滚动、广告条
- day58_lucene详细
- Spring学习-33:Spring中的事务管理之声明式事务(基于切面自动代理)
- (POJ 1151,HDU 1542,ZOJ 1128) Atlantis
- Column 'id' in where clause is ambiguous
- Windows系统功能模拟 C++(EasyX插件)—— 1st 介绍
- 架构之路--多线程下的设计模式 Master worker并行计算模式
- js读取元素值currentStyle和getComputedStyle
- Java 24 点 杭电1427
- android学习(二十) 执行网络操作(二) 管理网络使用
- 常用正则表达式
- 《JAVA设计模式》之单例模式
- 最短距离