mysql下出现Unknown column ‘xx’ in 'on clause’的完全解决方法
在项目中执行查询无结果，在数据库运行sql报错：Unknown column ‘xx’ in ‘on clause’ ！
Unknown column ‘xx’ in ‘on clause’
2024-03-27
41
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《
阿里云开发者社区用户服务协议》和
《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写
侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：
Unknown column ‘xx’ in ‘on clause’
目录
相关文章
|
3月前
|
SQL
[Err] 1052 - Column ‘roleId‘ in where clause is ambiguous
这篇文章解释了SQL查询中出现"Column ‘roleId’ in where clause is ambiguous"错误的原因，即在多表查询中，如果没有明确指定表名，相同的列名在where子句中会产生歧义，并提供了修正方法，即明确指定条件中所引用的列属于哪个表。
81
0
0
|
4月前
|
安全
Warning: Don’t paste code into the DevTools Console that you don’t understand or haven’t reviewed yo
Warning: Don’t paste code into the DevTools Console that you don’t understand or haven’t reviewed yo
391
0
0
|
12月前
|
数据库
解决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
264
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的解决办法
149
0
0
|
关系型数据库
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 解决办法
1488
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
202
0
0
|
关系型数据库
MySQL
数据库
|
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
413
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’
967
0
0
