【Error】Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is

最新推荐文章于 2024-05-31 17:04:50 发布
最新推荐文章于 2024-05-31 17:04:50 发布
阅读量431 收藏
点赞数 1
分类专栏： Linux mysql Java Mac 文章标签： mysql group by
Java 同时被 3 个专栏收录
43 篇文章 0 订阅
订阅专栏
Mac
27 篇文章 0 订阅
订阅专栏
Linux
11 篇文章 0 订阅
订阅专栏

由于使用Group by字段，及select 后的字段较多，导致此错误

1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by

解决方法：

Linux:  /etc/mysql/conf.d/mysql.cnf

vi编辑模式：新增

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

如下图：

然后重启mysql即可

/etc/init.d/mysqld restart 

 

 

参考

https://sourceforge.net/p/allocpsa/discussion/773745/thread/d36b44e0/?limit=25

邪神大叔
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘c.countFan
weixin_43802097的博客
05-12 1210
mysql中的sql__@@mode问题， 导致sql无法运行 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c.countFangWenCiShuByToday' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only
[Linux 完美解决]Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column
m0_48296376的博客
03-24 2072
错误 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 一、 其他参考文档 临时解决方法: Mysql解决SELECT list is not in GROUP BY clause and contains nonaggregated column 问题 另一个: mysql遇见Expression #1 of SELECT list is not in GROUP BY clau
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated ...
qq_59025975的博客
09-19 5176
在Mysql版本为5.7.25时，在使用使用group by 时，会出现Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated...错误,这个错误的原因是 group by后面需要加上，select中的所有字段。不然就会报这个错误。
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated...
working_hewei的博客
11-26 2198
记一个MySql的小坑，在Mysql版本为5.7.25时，在使用使用group by 时，会出现Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated...错误,这个错误的原因是 group by后面需要加上，select中的所有字段。不然就会报这个错误。 解决这个错误方法是更改Linu...
Expression #1 of SELECT list is not in GROUP BY clause and
最新发布
zhangsheXIN_的专栏
05-31 282
这个错误通常是由于MySQL 8.0版本的SQL模式中引入了ONLY_FULL_GROUP_BY，这个规则要求在SELECT语句、HAVING条件或者ORDER BY中使用的列，必须是聚合函数的参数或者是GROUP BY子句中的列。这个错误表明在一个需要使用GROUP BY的查询中，SELECT列表中的某些表达式没有出现在GROUP BY子句中，或者HAVING子句中使用了聚合函数之外的列。如果不希望改变查询逻辑，可以考虑调整SQL模式，移除ONLY_FULL_GROUP_BY规则。
解决MYSQL查询报错 Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
谷咕咕
10-26 736
原因：在MySQL5.7.5后，默认开启了ONLY_FULL_GROUP_BY，所以导致了之前的一些SQL无法正常执行，其实，是我们的SQL不规范造成的，因为group by 之后，返回的一些数据是不确定的，所以才会出现这个错误。这个是一次性的，也可以在my.ini里面设置。
解决大于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异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
12-14
在MySQL中，错误提示 "[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column…” 指的是在执行包含`GROUP BY`子句的查询时，你试图对未在`GROUP BY`子句中...
mysql遇到Expression.docx
03-05
在MySQL中，当你尝试执行一个包含`GROUP BY`子句的查询时，可能会遇到"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"这样的错误。这个错误提示表明你的查询违反了`...
MySQL使用中遇到的问题记录
12-15
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION ``` 之后重启MySQL服务使更改生效。 其次，清空表数据通常有两种方式。第一...
SQL 错误 [1055] [42000]: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggreg
quanqxj的博客
01-15 6902
在使用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遇见Expression this is incompatible with sql_mode=only_full_group_by
流风雨情的博客
11-20 228
当在查这个sql的时候 SELECT a.*, count(b.id) FROM stu a LEFT JOIN stu b ON a.class = b.class AND a.score < b.score GROUP BY a.id Expression #2 of SELECT list is not in GROUP BY clause and contains nona...
MYSQL报错 ：Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
sahbnuymiy的博客
01-26 567
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
mysql报错SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xxx‘.
Gblfy_Blog
10-14 962
mysql报错SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xxx‘.
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column……报错的解决办法
weixin_65549694的博客
06-20 1714
问题原因：这个报错是执行有GROUP BY的语句时出现的,原因是MySQL启用了默认的only_full_group_by SQL模式,导致GROUP BY语句报错.解决办法：打开mysql的安装目录找到my.ini配置文件，添加下面这行代码： 具体位置如下：然后，右击此电脑-->管理->服务->找到mysql服务，重启此服务，问题解决。...
使用Intellij IDEA开发JavaWeb项目时现“SELECT list is not in GROUP BY clause and contains nonaggre”的问题（项目总结）
REDANDBLUE_OvO的博客
12-03 424
1、问题说明 当使用 Intellij IDEA 写项目时，需要操作数据库，但过程中出现了以下问题： Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sss.month_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mod
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
weixin_45626288的博客
03-29 3039
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wsq.m.chat_room_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...原因及解决方案
热门推荐
江海寄余生的博客
03-30 1万+
最近公司新建了一个项目，在项目中需要用到group by进行聚合计算，在计算的同时也要查出一些其他字段来返回给前端。于是就有了这个错误的出现。 先简单复现我所写的sql，其实sql非常简单。 select channel_name as channelName, brand_name as brandName, sum(actual_value) as actualValue, sum(actual_value_ty) a
Error Code: 1055. Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column
10-29
这个错误信息是MySQL数据库返回的错误信息，意思是在SELECT语句中，第三个选择的列不在GROUP BY子句中，且不是聚合函数，这与当前的SQL模式(only_full_group_by)不兼容。这个错误通常是由于在GROUP BY子句中没有包含...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值