where clause is ambiguous
来源:互联网 发布:沈宏非的淘宝店 编辑:程序博客网 时间:2024/06/10 04:04
在一次使用mysql数据库查询的时候出现错误提示 Column 'pid' in where clause is ambiguous。
这个错误in where clause is ambiguous 多半是因为多表查询的时候几个表中同时出现了某个相同的列名,而在查询条件WHERE后面又没有指定是那个表,而引起的,又或者是查询结果里面有两个相同的列名,而没有指定是哪个表。
使用的时候可以这样,mysql查询前面加表名可避免出现这个错误 。
0 0
- where clause is ambiguous
- Mysql, 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 '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
- 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
- Integrity constraint violation: 1052 Column "order_id" in where clause is ambiguous
- php des和 java des
- 单选 性别选项(男,女)提交问题
- 嵌入式Linux操作系统学习规划
- 終戦の日、各党が談話発表 安保法案への賛否にも言及
- 火狐浏览器插件vimperator的常用命令
- where clause is ambiguous
- 制作cocoapods国内镜像
- 中介者模式
- Linux进程间通信——使用信号
- planahead调试程序
- 测试分析例子--杯子,圆珠笔
- Myeclipse在mac中如何配置jdk
- UVa-400 Unix ls
- ZOJ 3703 Happy Programming Contest(0-1背包)