ERROR 1052 : Column 'eid' in field list is ambiguous
来源:互联网 发布:手机淘宝实名认证激活 编辑:程序博客网 时间:2024/06/14 17:10
今天多表查询 写sql语句出错!
提示为ERROR 1052 : Column 'eid' in field list is ambiguous
错误的sql="select cid,cname,eid,ename,count,endtime from card,users where card.eid=users.eid and bid=?"
网上收索后知道是 因为在连接多个表查询的时候要制定字段的表,不然数据库不知道如何查询。
也就是 你要查询的 cid eid 在card users都出现过 数据库不知道从哪里开始查询
改正这点就顺利通过了select card.cid,card.cname,card.eid,users.ename,card.count,card.endtime from card,users where card.eid=users.eid and bid=?
0 0
- ERROR 1052 : Column 'eid' in field list is ambiguous
- column 'id' 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 field list is ambiguous
- 疑难杂症(5) -- Column 'id' in field list is ambiguous
- MySQLIntegrityConstraintViolationException: Column 'id' in field list is ambiguous
- MySQL 表自连接 出现 Column 'ename' in field list is ambiguous
- mysql Error:1052 Column 'xxx' in where clause is ambiguous
- 错误代码: 1052 Column 'sys_date' in where clause is ambiguous
- Error Code: 1054. Unknown column 'employeeNumber' in 'field list'
- 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 'id' in where clause is ambiguous
- Column 'is_valid' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- 气象业务系统切换国际标准时间
- JavaScript语言基础-环境搭建
- RelativeLayout, Framelayout的理解
- javax.naming.NameNotFoundException: myqueue not bound
- 查找最小的k个数
- ERROR 1052 : Column 'eid' in field list is ambiguous
- C++ 变量相除(/)注意事项 double 型比float型要快一点
- POJ 2586-Y2K Accounting Bug
- C++中的const与指针
- Android string.xml 显示特殊符号
- Google Code Jam 2014 1A - Charging Chaos (思维)
- 嵌入式Linux开发环境搭建
- android最简单菜单
- Gnome浏览器使用