MySql错误；ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nona

于 2023-10-06 16:31:53 发布
阅读量151 收藏
点赞数
文章标签： mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_52695807/article/details/133613166
版权

意思是MySql在低版本（5.7.x以下）中允许select后面的非聚合列不出现在group by中。以下sql在低版本中是可以运行的，但是在5.7及以上版本会报错。也就是查询的字段select,要出现在group by后面。

peter.pang
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
12-15
如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测...
mysql遇到Expression.docx
03-05
mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
热门推荐
lxw1844912514的博客
09-18 4万+
报错:ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'work_ad.api_community_pic.id' which is not functionally dependent on columns in GROUP B...
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP
叶落无痕的博客
06-18 2870
1.原因： MySQL 5.7.5和up实现了对功能依赖的检测。如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测到功能依赖项，only_full_group_by在默认情况下是不启用的。关于前5.7.5行为的描述，请参阅MySQL 5.6参考手册。) 2.解决： 打开mysql配置文件，在[mysql.
MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
12-14
[Err] 1055 – Expression #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 ...
MySQL使用中遇到的问题记录
12-15
#1 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by 解决办法 # 设置正确的 sql_mode 即可解决 # 登陆MySQL ...
ERROR 1055 (42000): Expression #1 of SELECT list is not in
lxw1844912514的博客
02-04 1024
报错:ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains no...
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate...
我是jjking`
09-09 601
执行sql语句报错： ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.fruits.f_id' which is not functionally dependent on columns in GROUP BY c...
mysql使用group by分组时出现错误ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and
antrychme的博客
08-22 2万+
使用mysql，group by分组时出现错误： ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘advanced.dept.deptno’ which is not functionally dependent on c...
mysql报错：ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nona
Lucky boy的博客
12-23 1312
执行sql分组 mysql报错：ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nona
ERROR 1055 (42000): Expressionof SELECT list is not in GROUP BY clause sql_mode=only_full_group_by
look look
07-24 422
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘mome.a.type’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 解决办法 首先通过SQL
mysql错误-1055 - Expression #1 of SELECT list is not in GROUP BY clause 解决方案
最新发布
liqinglonguo的博客
06-15 5921
这个错误会发生在mysql 5.7 版本及以上版本mysql 5.7版本以上默认的sql配置是:sql_mode=“ONLY_FULL_GROUP_BY”，这个配置严格执行了"SQL92标准"。找到sql_mode，将其中的ONLY_FULL_GROUP_BY属性去掉，如果没有sql_mode配置，就在 [mysqld]下面追加一下即可。由于开启了ONLY_FULL_GROUP_BY的设置，如果select 的字段不在 group by 中，only_full_group_by不兼容”
SQL 错误 [1055] [42000]: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggreg
quanqxj的博客
01-15 6628
在使用group by时，报错信息如下： ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mome.a.type' which is not functionally dependent on columns in GROUP...
MySQL异常ERROR 1055 (420ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause
Quest_sec的博客
05-01 967
大致错误如：ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘aaa.test.age’ which is not functionally dependent on columns in GROUP BY clause; thi...
error 1055 (42000): expression
04-06
error 1055 (42000)是MySQL数据库报错信息，表示在执行SELECT语句时，使用了GROUP BY语句，而且GROUP BY语句中的字段不在SELECT语句中出现，导致查询不合法，因此出现“expression”错误提示。解决方法是将GROUP BY语句中的字段添加到SELECT语句中，或者使用聚合函数对字段进行计算。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值