MySQLIntegrityConstraintViolationException: Column 'id' in field list is ambiguous
来源:互联网 发布:周易算法 编辑:程序博客网 时间:2024/06/11 22:59
今天写代码碰到了这样一个问题:MySQLIntegrityConstraintViolationException: Column 'id' in field list is ambiguous。一看就是死在了mybatis的配置文件上了。因为人家说的是列属性“id”在所属领域中定义不明确。
进入XML文件中查找“id”果然在连接查询中发现了问题,一般ID是多数表的共有属性,联表查询时需要明确需要的是哪张表的id。主要是可能是用了
<sql id="Base_Column_List"> id, 。。。。</sql>然后在sql语句中直接使用
<include refid="Base_Column_List"/>导致。这个时候只能重新写一个表明id属于哪张表的List来代替Base_Column_List了。
解决id定义不明确问题这个异常就解决了
阅读全文
0 0
- MySQLIntegrityConstraintViolationException: Column 'id' in field list is ambiguous
- column 'id' in field list is ambiguous
- 左链接Column 'id' in field list is ambiguous
- 疑难杂症(5) -- Column 'id' in field list is ambiguous
- ERROR 1052 : Column 'eid' in field list is ambiguous
- 错误代码: 1052 Column 'stu_id' in field list is ambiguous
- 出现 Column 'sp_id' in field list 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 'id' in where clause is ambiguous
- MySQL 表自连接 出现 Column 'ename' in field list is ambiguous
- Unknown column 'user0_.id' in 'field list'
- 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
- 《Linux内核设计与实现》读书笔记(四)- 进程的调度
- for循环/递归 实现九九乘法表
- Nginx
- Oracle:集合(一)
- 初始化资源管理器 winform
- MySQLIntegrityConstraintViolationException: Column 'id' in field list is ambiguous
- Android编程权威指南第三版挑战练习三
- Elasticsearch基本CRUD操作
- 常用Linux命令
- PHPfor循环和递归实现九九乘法表
- 理解NS2中的OTcl/tclCL
- 简单易懂的ssm(spring mvc,mybatis,spring)开发实例分析
- Struts2的Action向JSP传输List集合并且将数据显示在页面上
- IOS移动操作系统架构图