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

最新推荐文章于 2024-07-03 08:00:00 发布
最新推荐文章于 2024-07-03 08:00:00 发布
阅读量1k 收藏
点赞数
分类专栏： Mysql 文章标签： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_37380784/article/details/122037712
版权

数据库之前的版本是5.7，更换数据库到8.0之后，突然之前的sql执行报错

mysql 5.7+中 默认启用了 ONLY_FULL_GROUP_BY
这个表示什么呢，从字面上看，大概就是一种严谨的SQL模式，类似于Oracel那些Group by语句，就是你查询那些字段，group by的时候也要写上哪些字段。知道原因了，那把这个模式去掉就可以了

在my.ini中添加

[mysqld] 
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,
NO_ENGINE_SUBSTITUTION

Docker下修改mysql配置文件

第一步： 找到要修改的镜像

docker ps

第二步： 进入要修改的镜像

docker exec -it 容器ID /bin/bash

第三步： 进入要修改的文件目录

cd /etc/mysql

第四步： 安装vim

如果不安装vim在使用vim的时候会报找不到，在修改docker中mysql的配置文件，无法使用vi命令。

apt-get update
apt-get install vim

第五步： 修改my.cnf配置文件

vi my.cnf

第六步： 退出容器

如果要退出bash有2种操作：1）Ctrl + d 退出并停止容器；2）Ctrl + p + q 退出并在后台运行容器；

第七步：重启docker容器

docker restart 容器ID

 

 

余_小凡
关注
专栏目录
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
码农研究僧的博客
04-24 1444
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
mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DN金猿的博客
06-28 239
经过查询资料发现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使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...
weixin_43697366的博客
06-08 629
今天接口突然返回这个错误： 因为一直使用的是阿里云 rds实例，之前接口返回正常，没有更新过代码，因为最近重新购买了该实例rds,所以问题定位到这个上边，后来查询是mysql的配置是默认了参数的sql_mode=only_full_group_by MySql在低版本（5.7.x以下）中允许select后面的非聚合列不出现在group by中。以下sql在低版本中是可以运行的，但是在5.7及以上版本会报错 通过该命令查询：SELECT @@sql_mode 解决方法就是在对应rds实例化的.
报错：Expression #1 of SELECT list is not in GROUP BY .......with sql_mode=only_full_group_by
m0_46420991的博客
06-03 163
报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘hospital.d.rugstoreId’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 解决方案： 在MySQL执行下列语句
解决SQL中的“Expression #1 of SELECT list is not in GROUP BY clause“错误
最新发布
沉淀、分享、成长，让自己和他人都能有所收获！
07-03 4万+
在日常开发中，我们经常会遇到SQL查询中的一些错误，尤其是在处理复杂的查询时。今天，默语将带大家一起深入探讨并解决一个常见的SQL错误：“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column”。通过这篇文章，您将了解该错误的原因及其解决方案，提升您的SQL技能。在SQL查询中，GROUP BY子句用于将结果集按一个或多个列进行分组。
mysql sql查询拼上group by问题
weixin_37692315的博客
06-09 132
报错日志： #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 xxxx sql_mode=only_full_group_by
GalenGao
07-17 340
异常描述 公司的老项目代码拿到本地启动的时候，mysql 报了以下错误： Caused by: org.hibernate.exception.SQLGrammarException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'framework_mj.agile_board_star.id' which is not functionally dependent on
Mysql 报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”
Kaysen_7
05-14 3450
- 抛出异常 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre - 解决方案 set @@sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_U...
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`子句中...
解决大于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 #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法
m0_52789121的博客
06-07 1292
今天使用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遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
qq_1905369638
08-08 2355
问题： 今天遇到项目部署到Ubuntu上，发现数据库查不出来，报错是Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 大概是第二次遇到这个问题才想起来写这个博客记录… select name from student group by classid; 会出现下列错误这个错误 mysql5.7默认group by 只能配合聚合函数使用如max,count(*),等 这样是没问题的 原因： 因为MySQ
mysql Expression #1 of SELECT list is not in GROUP BY
YZBPXX
05-18 154
出现这个错误 可以用 mysql>select @@sql_mode; 查看@@sql_mode 是否包括了ONLY_FULL_GROUP_BY这个模式 只在当时有效 SET sql_mode=(SELECT REPLACE(@@sql_mode,‘ONLY_FULL_GROUP_BY’,’’)); 永久有效需要更改配置文件, linux 在/etc/my.cnf , windows在my.ini 设置(没有ONLY_FULL_GROUP_BY 后的select @@sql_mode;.
MySQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xx
健身变秃，coding变强
04-29 1万+
MySQL group by报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.test_baobiao.qty' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
MySQL报错： Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
陈一一同学的博客
06-21 2725
MySQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zx_ds.biz_table_ver.ver_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n### ....
Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY
zhanghua0324的博客
04-24 2744
在使用MySQL5.7.32 分组查询出现Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY 出错原因：MySQL 5.7及以上功能依赖检测功能，如果启用了ONLY_FULL_GROUP_BY SQL 模式（默认情况下），MySQL将拒绝选择列表，HAVING 条件或 ORDER BY 列表的查询引用在 GROUP BY 子句中既未命名的非集合列，也不在功能上依赖于它们。 ..
myql报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
IT大神帅杰的博客
05-24 397
myql报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
MySQL解决报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
weixin_59633478的博客
12-09 566
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rent.menu.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column【bug】解决方案
qq_42265220的博客
03-29 1412
问题场景： select stuid from student_table GROUP BY stuAccount HAVING count(stuAccount)>1; 运行完这条sql语句后mysql就报了这个错误。 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column… 解决方案： 1.对于已经存在的数据库 执行下面的sql语句即可（没有效果重启数据库服务） SE
解决 Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY错误
07-28
- *2* [解决 Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY错误](https://blog.csdn.net/Seven_0110/article/details/112356269)[target="_blank" data-report-click=...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值