Ambiguous column name
来源:互联网 发布:信越7783硅脂淘宝 编辑:程序博客网 时间:2024/06/05 08:07
错误:Ambiguous column name 一般出现在多张表(这些表具有同名的column)进行连接后,select 了这些同名的column的情况下,例如:
Table A结构如下:
abcTable B结构如下:
cde如果进行如下操作,则会报“Ambiguous column name‘c’”的错:
SELECT c FROM A JOIN B ON A.c = B.c
原因:select出来的c列无法识别是A中的c列还是B中的c列。
解决方案:
SELECT A.c FROM A JOIN B ON A.c = B.c
0 0
- Ambiguous column name
- Ambiguous column name
- ambiguous column name解决办法
- Ambiguous column name
- ambiguous column name解决办法
- QT笔记:ambiguous column name:
- sqlite: ambiguous column name解决方法
- SQL server error: Ambiguous column name
- Column 'id' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- column 'id' in field list is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'Email' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'is_valid' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column ' ' in where clause is ambiguous
- column 'typeid' in where clause is ambiguous
- linux中more与less的区别
- mysql创建存储过程
- Android安全–ELF文件格式解析
- iptables脚本
- ClamAV源码配置安装测试
- Ambiguous column name
- 一看就懂的ReactJs入门教程(精华版)
- kafka实践
- jquery 取值 radio 问题
- #1064-You hava an error in your SQL syntax
- codeforces #345 div.2 B Beautiful Paintings
- 【leetcode】【169】Majority Element
- CK-----------------ocx端口打开失败
- 47. Permutations II