mysql 连表查询分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题

箐藩

已于 2023-02-15 14:19:55 修改

阅读量332

点赞数

分类专栏： mysql分组 java 文章标签： mysql list 数据库

于 2021-11-05 11:34:42 首次发布

本文链接：https://blog.csdn.net/weixin_42385565/article/details/121159739

版权

java 同时被 2 个专栏收录

2 篇文章 0 订阅

订阅专栏

mysql分组

1 篇文章 0 订阅

订阅专栏

第一次写博客记录一下把本人菜狗一个对于链表查询我这边是报一个分组错误百度了很久基本都是让修改mysql的校验要不就是使用mysql5.7以下的版本，

所以直接就关闭了，找了一个前辈说自己的sql有问题但是sql客户端能执行后台调用接口就会报错贴个sql 容易指出问题

在后台执行就会报分组问题后来前辈说连表查询的时候的对没有聚合函数的字段也得放到分组后面然后就改成这样了就可以运行了

以前用的是mysql5.5的语法没有检测机制一直以为自己写的没问题记录一下。

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

箐藩

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录

mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column

DN金猿的博客

06-28

397

经过查询资料发现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 nonaggre报错

weixin_43140656的博客

11-28

704

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre …后面一大堆出错就是这样我们可以在网上看到很多解释 MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查...

参与评论您还未登录，请先登录后发表或查看评论

mysql连表分组报错---- sql_mode=only_full_group_by问题解决

runwuwushengxiyu的博客

09-30

mysql连表分组报错---- sql_mode=only_full_group_by问题解决

mysql8.0遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题解决

代码搬运工的博客

08-08

1528

mysql版本8.0，使用group by语句时提示Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的错误信息，经查需要修改默认的sqlmode，默认的sqlmode是ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_E.

mysql报错Expression #1 of SELECT list is not in GROUP BY clause and contains non

4396的博客

11-19

424

项目运行得好好的，换了个数据库服务器后就报这个错了版本原因记录解决办法 //执行语句 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'; set session ...

mysql查询报错_mysql分组查询报错

weixin_39633954的博客

01-21

203

执行sql group by查询时报错SELECT id from userz GROUP BY usernameExpression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.原因：mysql实现了对功能依赖的检测，如果启用了only_full_group_by ...

解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated

09-09

当执行包含`GROUP BY`语句的查询时，如果`SELECT`列表中的列没有出现在`GROUP BY`子句中，且该列没有被聚合函数（如`SUM`, `AVG`, `MAX`, `MIN`等）处理，MySQL会抛出`Expression #1 of SELECT list is not in GROUP...

MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法

m0_52789121的博客

06-07

1311

今天使用mysql简单的一句分组查询语句（GROUP BY）报错了。查了问题原因和解决方法，成功解决。原因：使用GROUP BY 语句违背了sql_mode=only_full_group_by。因为mysql版本5.7之后默认的模式是ONLY_FULL_GROUP_BY。官网文档的原话：说人话，大概意思就是说（使用google翻译）：1、先使用SQL查询sql_mode 2、重新设置sql_mode，删除ONLY_FULL_GROUP_BY 3、退出重进再次执行查询语句，...

mysql的groupBy问题 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated

最新发布

m0_73774439的博客

05-09

515

日常工作上遇到的mysql存在groupby字段无法查询的问题。

mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题

mzhmzj的博客

08-20

1372

问题出现的原因：MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用在GROUP BY子句中既未命名的非集合列，也不在功能上依赖于它们。（5.7.5之前，MySQL没有检测到功能依赖关系，默认情况下不启用ONLY_FULL_GROUP_BY。有关5.7.5之前的行为的说明，请参见“MySQL 5.6参考手册”。）解决方法一：打开navcat，用sql查询.

mysql查询出现1055错误，ER_WRONG_FIELD_WITH_GROUP: Expression #1 of SELECT list is not in GROUP BY clause。。。

u011599033的博客

04-08

1508

在navicat上查询时一直报错1055错误在浏览器中请求network中显示：ER_WRONG_FIELD_WITH_GROUP: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'book.book.category' which is not functionally dependent on columns in GROUP BY clause; this is in

mysql sql查询拼上group by问题

weixin_37692315的博客

06-09

145

报错日志： #Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #57 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘gbw.gs.ID’ which is not functionally dependent on columns in GROUP BY clause; this is incom

Expression #1 of SELECT list is not in GROUP BY clause and ...

weixin_43076448的博客

06-28

271

windows系统中的mysql使用group by分组时出现的错误。一、修改my.ini文件中的[mysqld]下添加如下信息： sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 二、重启mysql服务

Expression #1 of SELECT list is not in GROUP BY错误

余_小凡的博客

12-20

1079

GROUP BY，mysql5.7升级到mysql5.8

Expression #1 of SELECT list is not in GROUP BY .......with sql_mode=only_full_group_by

weixin_45507672的博客

06-12

146

SELECT VERSION(),@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

查询数据库参数错误：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '

LP1325308489的博客

04-02

1275

查询数据库参数错误：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'data_transaction.demand_feedback.id' which is not functionally dependent on columns in GROUP BY clau...

解决Mysql5.7以上版本，使用group by抛出Expression #1 of SELECT list is not in GROUP BY clause and contains no异常

weixin_39522272的博客

07-22

231

出现原因： MySQL 5.7.5和up实现了对功能依赖的检测。如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测到功能依赖项，only_full_group_by在默认情况下是不启用的解决方法：查看sql_mode select @@sql_mode; 不重启设置sql_mode set sql_mode=‘STR

mysql数据库版本问题Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated colum

tyyking的博客

11-24

8127

Mysql Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xx‘

m0_50176078的博客

09-09

599

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre

09-26

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘grades.order_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible ...