mysql下出现Unknown column ‘xx’ in 'on clause’的完全解决方法
在项目中执行查询无结果，在数据库运行sql报错：Unknown column ‘xx’ in ‘on clause’ ！
Unknown column ‘xx’ in ‘on clause’
2024-03-27
53
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《
阿里云开发者社区用户服务协议》和
《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写
侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：
Unknown column ‘xx’ in ‘on clause’
目录
相关文章
|
数据库
解决which is not functionally dependent on columns in GROUP BY clause；...sql_mode=only_full_group_by
解决which is not functionally dependent on columns in GROUP BY clause；...sql_mode=only_full_group_by
312
0
0
|
存储
SQL
关系型数据库
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column的解决办法
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column的解决办法
261
0
0
|
SQL
关系型数据库
数据库
|
关系型数据库
MySQL
Linux
SQLSTATE[HY000]: General error: 1364 Field ‘xxx’ doesn't have a default value 解决办法
SQLSTATE[HY000]: General error: 1364 Field ‘xxx’ doesn't have a default value 解决办法
1859
0
0
|
SQL
数据库
1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause
1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause
211
0
0
|
C++
|
SQL
关系型数据库
MySQL
报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregat
报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregat
437
0
0
![报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregat](https://ucc.alicdn.com/pic/developer-ecology/738a5899ebc049ee934978bfeeca615d.png?x-oss-process=image/resize,h_160,m_lfit)
AttributeError： ‘DatetimeProperties’ object has no attribute ‘weekday_name’ 的解决方法
‘DatetimeProperties’ object has no attribute ‘weekday_name’
1024
0
0
|
PHP
【PHP报错集锦】Integrity constraint violation: 1052 Column 'vt_id' in where clause is ambiguous
【PHP报错集锦】Integrity constraint violation: 1052 Column 'vt_id' in where clause is ambiguous
341
0
0
热门文章
最新文章
1
流批一体的近实时数仓的思考与设计
2
Nginx报错403 forbidden几个解决方法
3
丰富、连接、待集成—MaxCompute 生态再出发
4
【实战】锐捷AC+AP配置WLAN基本服务系列
5
为什么说流处理即未来？
6
securecrt克隆会话与sshd 的 MaxSessions
7
Elasticsearch 备忘
8
C++ Exercises（六）
9
勒索病毒出现新变种 传播方式与WannaCry类似
10
FCKEditor使用说明
1
基于EKF扩展卡尔曼滤波的一阶环形倒立摆控制系统simulink建模与仿真
32
2
小模型也能有类o1的慢思考能力？使用CAMEL生成CoT数据、Unsloth微调Qwen2.5-1.5B模型并上传至Hugging Face
55
3
《AI赋能共享经济：资源配置与服务质量的双重优化》
31
4
《AI引领传统企业：数字化转型与商业创新的破局之路》
38
5
《AI助力生物学：基因编辑与蛋白质结构解析的加速引擎》
31
6
《AI赋能自由职业：开启竞争力提升新征程》
28
7
《量子AI：突破量子比特稳定性与容错性的关键瓶颈》
25
8
Workforce 应用示例：黑客松评审团
26
9
使用 Qwen 生成数据模型和进行结构化输出
105
10
实现时间序列的小波相干性分析，并画出图谱
30