GROUP BY clause and contains nonaggregated 报错处理

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

1055 - Expression #16 of SELECT list is not in GROUP BY clause and contains nonaggregated column 报错处理

源码想移植到新的机器，MySQL 使用PHPStudy 安装 升级到5.7.26 。
一切准备就绪但是，出现以上错误。

话不多说解决办法，

1、主要原因
Mysql默认
的 sql_mode 默认 ONLY_FULL_GROUP_BY 值，需要把它去掉。

2 去掉办法
尝试很多种办法，比如
MySQL>set @@global.sql_mode=(select replace(@@global.sql_mode,’ ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’,’’));
都无法去掉。
3 正确办法 windows 系统里，
编辑MySQL 安装目录里的 my.ini
增加一行
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
(只要把ONLY_FULL_GROUP_BY 去掉即可)

保存后，重启Mysql 问题解决。

noya202020
关注
mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DN金猿的博客
06-28 372
经过查询资料发现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的解
科技改变人类，技术成就未来
08-09 2436
在使用 MySQL 时，可能会遇到这样的错误提示：“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column”。这通常是由于在 GROUP BY 查询中，SELECT 列表中的某些列没有被包含在 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
【解决方案】MySQL报错 SELECT list is not in GROUP BY clause and contains nonaggregated column
最新发布
一起寻找DX3906-探索未知
08-29 886
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解决方法
m0_67882861的博客
11-07 4070
因为sno属性是主码，即primary key，经测试发现group by **，**为主码的属性名时，select语句中的查询列没有在group by中出现，也是允许的。红色部分可以发现sc.sno与studen.sno都没有在GROUP BY的列中，但执行语句依旧正常，因为使用了聚集函数。执行mysql语句，select 选择的列不仅仅只有sno，为什么正常输出？存书（书号，书名，出版社，版次，出版日期，作者，书价，进价，数量）现有两表Student表以及SC表(选课表)。student表结构。
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ...
ajphsb0849的博客
10-12 164
解决方法一： SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); 优点：不用重启mysql 缺点：重启mysql后还会出现标题错误 SELECT @@global.sql_mode; 查询全局的 @@session.sql_mode 当前回话的 上面的只是修改当前回话，需要修改全局的s...
mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic
A乐神的博客
12-15 8019
mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic
使用group by语句时，报错，获取不到数据，出现SELECT list is not in GROUP BY clause and contains nonaggregated column 问题
qq_27346503的博客
10-03 2729
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 functionally dependent on columns in GROUP BY clause; th
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.
weixin_40925480的博客
11-03 1145
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...
weixin_43697366的博客
06-08 647
今天接口突然返回这个错误： 因为一直使用的是阿里云 rds实例，之前接口返回正常，没有更新过代码，因为最近重新购买了该实例rds,所以问题定位到这个上边，后来查询是mysql的配置是默认了参数的sql_mode=only_full_group_by MySql在低版本（5.7.x以下）中允许select后面的非聚合列不出现在group by中。以下sql在低版本中是可以运行的，但是在5.7及以上版本会报错 通过该命令查询：SELECT @@sql_mode 解决方法就是在对应rds实例化的.
Mac MySql8报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated
Jack_Tpy的Java学习之旅
07-28 856
报错信息： 1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘fbjs.mscc.ContactTime’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Time: 0
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...解决方案
热门推荐
study_in的博客
06-19 7万+
MySQL5.7.5后only_full_group_by成为sql_mode的默认选项之一，这可能导致一些sql语句失效。 比如在使用group by进行分组查询报错 1 查看自己的sql_mode配置: 在sql命令行中输入select @@sql_mode;这时我们能够看到自己的sql_mode配置,其中如果有ONLY_FULL_GROUP_BY,那它就是group by查询报错的罪魁祸...
MySql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
fxjzzyo的博客
07-09 3097
更新MySql表中的一行数据时遇到这样一个报错：[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 BY clause; 本文章记录了该问题的解决过程。
MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法
snow_love_xia的博客
12-27 4230
MySQL 5.7.5 开始，默认 SQL 模式包括 ONLY_FULL_GROUP_BY。（在 5.7.5 之前，MySQL 不检测函数依赖，并且默认不启用 ONLY_FULL_GROUP_BY。）这可能会导致一些sql语句失效。确实sql_mode=ONLY_FULL_GROUP_BY。直接解决吧，我本地用的homestead，先根据文档说的查看一下本地的数据库的配置，进入数据库，输入命令。将ONLY_FULL_GROUP_BY去掉。进入配置文件所在目录。
解决大于5.7版本mysql的分组报错 #1 of SELECT list is not in GROUP BY clause and contains nonaggregated(自用)
qq_37507261的博客
07-11 233
错误信息： Caused by: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘db_samrlaw.tcp.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql
mysql group by 报错Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated c
wuxiaopengnihao1的博客
09-05 4086
这是MySQL8.0默认开启only_full_group_by模式导致的，该模式限定select后面跟的列，在group by后面必须要有。好了， 以上是本文所有内容，希望对大家有所帮助，也希望大家对。多多支持，你们的支持是我创作的动力！：该方式重启mysql会失效。修改配置文件my.cnf。重启mysql即可。
mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated 的问题
keep12moving的博客
11-20 249
https://blog.csdn.net/qq_34707744/article/details/78031413
In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column...
0bug0warning的博客
12-05 1万+
maven项目报错error: expression #2 of SELECT list contains nonaggregated column 'newhelp.appr.title'; this is incompatible with sql_mode=only_full_group_by 这是因为随着MySQL版本更新带来的问题，在MySQL5.7版本之后对group by进行了优...
mysql遇见contains nonaggregated column 'information_schema.PROFILING.SEQ'异常
weixin_33980459的博客
04-20 2227
报错如下：[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 GROU...
ORDER BY clause is not in GROUP BY clause and contains nonaggregated
09-29
ORDER BY clause is not in GROUP BY clause and contains nonaggregated column是MySQL中的一个报错信息。它表示在使用GROUP BY子句进行分组查询时，ORDER BY子句中的列没有包含在GROUP BY子句中，并且没有被聚合...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值