MYSQL 错误解决 SELECT list is not in GROUP BY clause and contains nonaggregated column

最新推荐文章于 2025-06-17 14:14:27 发布

蓝图

最新推荐文章于 2025-06-17 14:14:27 发布

阅读量4.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： MySql

本文链接：https://blog.csdn.net/lbuskeep/article/details/102951439

MySql 专栏收录该内容

7 篇文章

订阅专栏

本文介绍了解决MySQL在Linux和Windows环境下启动时遇到的问题的方法。通过修改配置文件mysql.cnf或mysql.ini，添加特定的sql_mode设置，可以确保数据库服务正常运行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

温馨提示：1、如果是 linux 操作系统在 /etc/mysql/conf.d/mysql.cnf 下做修改

2、如果是 windows 操作系统在 mysql 目录下修改 mysql.ini

修改操作：

1、进入文件后在 [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

2、保存文件并重启mysql 服务，就可以解决上面的问题。

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

蓝图

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
打赏
打赏
打赏举报

举报

专栏目录

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

DN金猿的博客

06-28

1151

经过查询资料发现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 8.0.21 “SELECT list is not in GROUP BY clause and contains nonaggregated column...“错误解决方案

TuTuTu_Tu的博客

09-21

935

今天用EF框架生成Mysql实体模型时遇到了 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘STATISTICS.INDEX_TYPE’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

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

MySQL SyntaxErrorException SELECT list is not in GROUP BY 报错解决

C_V_Better的博客

03-04

724

错误是由于 MySQL 的模式引起的。通过修改 SQL 查询、修改 MySQL 配置或使用聚合函数，可以解决这个问题。在实际开发中，建议根据具体需求选择合适的解决方法。

MySQL：SELECT list is not in GROUP BY clause 报错解决方案

换条路吧，编程没意思的~

06-20

6163

MySQL 报错：SELECT list is not in GROUP BY clause and contains nonaggregated column 解决方案

mysql 8.0下的SELECT list is not in GROUP BY clause and contains nonaggregated column

最新发布

分享各类领域技术问题

06-17

252

mysql 8.0下的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 whic

A乐神的博客

12-15

8480

mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic

SELECT list is not in GROUP BY clause and contains nonaggregated column

qq_42334297的博客

09-10

8828

SELECT list is not in GROUP BY clause and contains nonaggregated column问题解决方案单次解决修改配置文件使用规范的sql语句问题在单独部署项目的时候遇到了这个问题，具体意思就是： SELECT列表不在GROUP BY子句中，且包含非聚合列意思应该就是SELECT的属性必须出现在GROUP BY语句中，即类似于SELECT a.name FROM user a GROUP BY a.name这种样子。问题根源应该是sql语句的问题，

mysql中SELECT list is not in GROUP BY clause and contains nonaggregated column解决办法

weixin_45810161的博客

01-02

3097

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 whic

weixin_63716356的博客

07-24

2112

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使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.

weixin_40925480的博客

11-03

1219

mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.

[Linux 完美解决]Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column

m0_48296376的博客

03-24

2231

错误 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

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

1309

this is incompatible with sql_mode=only_full_group_by

SELECT list is not in GROUP BY clause and contains nonaggregated column&&Job for mysqld.service fail

weixin_41340417的博客

12-02

1949

解决使用group by出现的问题

Mysql解决SELECT list is not in GROUP BY clause and contains nonaggregated column 问题

随笔

01-10

1675

解决办法：三步走，实测有效！！！ 1：--查看数据库sql查询模式 select @@GLOBAL.sql_mode; 2：-- 去除only_full_group_by 模式设置，保留第一步查询出来的其他配置项 set GLOBAL sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVIS...

【解决】 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报错 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column解决方法

m0_67882861的博客

11-07

5528

因为sno属性是主码，即primary key，经测试发现group by **，**为主码的属性名时，select语句中的查询列没有在group by中出现，也是允许的。红色部分可以发现sc.sno与studen.sno都没有在GROUP BY的列中，但执行语句依旧正常，因为使用了聚集函数。执行mysql语句，select 选择的列不仅仅只有sno，为什么正常输出？存书（书号，书名，出版社，版次，出版日期，作者，书价，进价，数量）现有两表Student表以及SC表(选课表)。student表结构。

SELECT list is not in GROUP BY clause and contains nonaggregated column解决和总结