Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated...

最新推荐文章于 2024-11-01 11:24:29 发布
原创 最新推荐文章于 2024-11-01 11:24:29 发布 · 2.3k 阅读 · 4 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

在MySQL 5.7.25版本中，使用Group By时遇到Expression#4 of SELECT list is not in GROUP BY clause and contains nonaggregated错误。本文介绍了解决该问题的方法，通过修改Linux服务器上的MySQL配置文件，调整sql_mode设置，以避免此类错误。

记一个MySql的小坑，在Mysql版本为5.7.25时，在使用使用group by 时，会出现Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated...错误,这个错误的原因是 group by后面需要加上，select中的所有字段。不然就会报这个错误。 

解决这个错误方法是更改Linux服务器mysql的配置文件。

第一步：sudo vim /etc/mysql/conf.d/mysql.cnf 

第二步：在[mysql] 下添加

[mysqld]
lower_case_table_names=1
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 （sudo service mysql restart）。

OK!
 

 

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #4 of SELECT list i
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
11-04 1053
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXXXX.l.rate' which is not functional...
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
码农研究僧的博客
04-24 3061
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'easy-admin.students.age' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated ...
qq_59025975的博客
09-19 6040
在Mysql版本为5.7.25时，在使用使用group by 时，会出现Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated...错误,这个错误的原因是 group by后面需要加上，select中的所有字段。不然就会报这个错误。
MYSQL:Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DXIANGH的博客
06-10 1858
mysql only_full_group_by问题
MYSQL查询报错 Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column，
陌子曦的专栏
05-07 4080
完整报错如下：Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sa.type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with s...
[Err] 1055 - Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
热门推荐
hhczy1003的专栏
08-23 1万+
这个错误发生在mysql 5.7.5 和以后上，因为5.7.5默认的sql模式配置是 ONLY_FULL_GROUP_BY，  这个配置启用的是 “严格ANSIsql 规则”，严格ANSI sql 规则要求在group by的时候，没有聚合的列，在group by的时候，必须全部包含在group by 的字段中。 没有聚合的列，指的是没有使用 max, min, count,
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
09-09
且该列没有被聚合函数（如`SUM`, `AVG`, `MAX`, `MIN`等）处理，MySQL会抛出`Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated`错误。这个问题在5.7版本之前并不严格检查，但在...
mysql版本升级出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column错
最新发布
爱媳妇儿爱编程
11-01 1317
mysql 升级版本出现experssion #2 ONLY_FULL_GROUP_BY错误问题解决
mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DN金猿的博客
06-28 1308
经过查询资料发现group by 聚合操作的时候，进行查询操作的列没有在group by 中出现，那么这个sql就是不合法的。主要原因就是设置的与sql_mode=only_full_group_by不兼容。今天在mysql5.7.x 升级到8.0.x版本的时候 项目接口报错。通过查询发现mysql5.7.5及以上的版本都会依赖检测功能,也就是默认会开启only_full_group_by。8.0.x的版本不支持NO_AUTO_CREATE_USER，去掉即可。
MySQL报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column whic
weixin_63716356的博客
07-24 2199
MySQL报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column whic字面翻译： SELECT 列表的表达式 #1 不在 GROUP BY 子句中，并且包含非聚合列“grades.order_id” 它在功能上不依赖于 GROUP BY 子句中的列； 这与 sql_mode=only_full_group_by 不兼容使用GROUP BY 语句违背了 sql_mode=only_
MYSQL报错 ：Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
sahbnuymiy的博客
01-26 967
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
解决MYSQL查询报错 Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
谷咕咕
10-26 954
原因：在MySQL5.7.5后，默认开启了ONLY_FULL_GROUP_BY，所以导致了之前的一些SQL无法正常执行，其实，是我们的SQL不规范造成的，因为group by 之后，返回的一些数据是不确定的，所以才会出现这个错误。这个是一次性的，也可以在my.ini里面设置。
#4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'itripdb.store
Xuyuqinga的博客
04-21 315
报错信息 Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘itripdb.store.store’ which is not functionally dependent on columns in GROUP BY clause; this is incompati...
1055 - Expression #4 of SELECT list is not in GROUP BY clause and contai sql_mode=only_full_group_by
Activiti工作流
12-31 2692
mysql分组查询出现下面错误 1055 - Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pfbuild.building_management.entrytime' which is not functionally dependent on columns i...
【解决】 SELECT list is not in GROUP BY clause and contains nonaggregated column
丑小鸭
01-18 1万+
出错情况 问题分析 出现此异常的原因是：如果启用了ONLY_FULL_GROUP_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用在GROUP BY子句中既未命名的非集合列，也不在功能上依赖于它们。 使用数据库的版本信息 mysql-8.0.15-winx64 解决策略 法 1 1 查看 sql_mode 1 使用以下命令查看自己的 sql_mode select @@global.sql_mode; 或者 show variables
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
SELECT list is not in GROUP BY clause and contains nonaggregated colum
weixin_42210195的博客
10-29 226
用group by 查询时抛出如下异常 解决方法： 1. set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; 2.set session sql_mode...
SELECT list is not in GROUP BY clause and contains nonaggregated column
niudaiche的博客
04-29 1548
SELECT list is not in GROUP BY clause and contains nonaggregated column 报错如下： Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sss.month_id’ which is not f...
SELECT list is not in GROUP BY clause and contains nonaggregated
White
07-20 643
mysql5.7版本sql_mode默认值。修改对于新的客户端连接生效！mysql5.7报错。mysql命令行执行。
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
07-29
引用\[1\]、\[2\]和\[3\]都是关于MySQL报错的信息，其中提到了"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"的错误。这个错误是由于在使用GROUP BY子句进行分组查询...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值