疑难杂症(5) -- Column 'id' in field list is ambiguous
来源:互联网 发布:mysql using filesort 编辑:程序博客网 时间:2024/06/06 09:04
问题描述
今天修改mybatis程序的时候报了这个错:ERROR 1052 (23000): Column ‘id’ in field list is ambiguous
百度了一下,发现是id字段指代不明,因为我关联了几个表查询,查询的时候,有一部分忘了加表名.字段名,所以报了这个错误。
解决方法
相同的字段名前面一定要加上表名.字段名。
如:
SELECT student.name, student.student_id, score.score FROM student INNER JOIN score ON student.student_id = score.student_id WHERE student.name=’mio’;
查询结果:
+——+————+——-+
| name | student_id | score |
+——+————+——-+
| mio | 1 | 99 |
| mio | 1 | 77 |
| mio | 1 | 88 |
| mio | 1 | 99 |
+——+————+——-+
4 rows in set (0.00 sec)
0 0
- 疑难杂症(5) -- Column 'id' in field list is ambiguous
- column 'id' in field list is ambiguous
- 左链接Column 'id' in field list is ambiguous
- MySQLIntegrityConstraintViolationException: 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
- TI SYS/BIOS的 创建工程实例
- suse添加源
- opengl学习例子官方资料网
- Android下载apk文件并安装
- ionic添加cordova插件-Splashscreen
- 疑难杂症(5) -- Column 'id' in field list is ambiguous
- php 的单例模式(二)
- js 经常用到的一下方法
- Qt连接mysql查询数据
- java.lang.UnsatisfiedLinkError: Native method not found解决方案
- C++11 小技巧之函数指针
- MYSQL中有关SUM字段按条件统计使用IF函数(case)问题
- 使用SolrJ创建索引
- 道具价格设定