出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法

最新推荐文章于 2025-03-06 21:09:40 发布
最新推荐文章于 2025-03-06 21:09:40 发布
阅读量2.8k 收藏 1
点赞数 1
分类专栏： BUG 文章标签： Mysql group by Bug
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/weixin_47872288/article/details/138139230
版权
当执行SQL时遇到User 1055错误，原因是MySQL的sql_mode设置了ONLY_FULL_GROUP_BY，要求SELECT中的非聚合列必须在GROUP BY中出现。解决方案包括在GROUP BY中加入列或使用聚合函数处理非聚合列，如MAX()。此外，也可修改MySQL配置文件禁用ONLY_FULL_GROUP_BY，但需谨慎。

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

目录

1. 问题所示

执行Sql的时候，出现如下问题

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

截图如下：

了解本专栏 订阅专栏 解锁全文 超级会员免费看
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated 【已解决】
JavaPub
08-30 945
然后重新运行语句，就可以正常查询了。在MySQL下输入如下语句。
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
MissWwg的博客
08-30 1万+
SQL92及更早版本不允许选择列表，HAVING条件或ORDER BY列表引用在GROUP BY子句中未命名的非分组列的查询。例如，在标准SQL92中，此查询是非法的，因为name选择列表中的未列出的列不会显示在GROUP BY： SELECT o.custid, c.name, MAX(o.payment) FROM orders AS o, customers AS c...
MySQL 报错: “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column“
最新发布
总结复盘，才能不迷失自己！
03-06 674
1.问题描述MySQL 中出现 “1055 - Expression #1 of 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
qq_36627328的博客
04-16 767
原因 出现此问题的原因是 MySQL 5.7.5 之后默认开启了 ONLY_FULL_GROUP_BY sql_mode。对此官方的解释：MySQL 实现了 函数依赖性 的检测。如果启用了 ONLY_FULL_GROUP_BY SQL模式（默认情况下是这样），MySQL 将拒绝 select list、HAVING condition 或 ORDER BY list 引用的未聚合列，这些列既不在 GROUP BY 子句中命名，也不在功能上依赖于它们。 解决方法 当然，最好的解决方法当然是修改优化 sql 语
MYSQL---之严格模式详解
weixin_45932995的博客
12-07 957
严格模式参数详解： sql_mode ONLY_FULL_GROUP_BY 对于GROUP BY聚合操作，如果在SELECT中的列，没有在GROUP BY中出现，那么这个SQL是不合法的，因为列不在GROUP BY从句中。简而言之，就是SELECT后面接的列必须被GROUP BY后面接的列所包含。如： select a,b from table group by a,b,c; (正确) se...
解决Mysql：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
热门推荐
qq_39954916的博客
09-06 4万+
SELECT 日期,地域,活跃度,COUNT(qq号) as qq个数 FROM (SELECT a.`日期`,a.`qq号`,a.`地域`,IF(b.msg>=200,'高活跃度','低活跃度') AS 活跃度 FROM table_user AS a LEFT JOIN table_act AS b ON a.`日期` = b.ftime AND a.qq号 = b.qq WHERE a.`地域` IN ('广东','广东省'))t GROUP BY 日期,活跃度; 以上代码运行报错.
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
qq_43227967的博客
03-30 8001
错误信息： [Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'scp.m.manufacturer_id' which is not functionally dependent on columns in GROUP BY clause;...
报错 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
loveliness_peri的博客
03-01 3万+
错误描述 [Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'community.tab_order_goods.goods_name' which is not functionally dependent on columns in GR...
【MySQL】报错1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated
weixin_61428498的博客
08-01 569
1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum完美解决！！！！！
MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
12-14
错误提示 "[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column…” 指的是在执行包含`GROUP BY`子句的查询时，你试图对未在`GROUP BY`子句中出现的列...
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘rea
weixin_43798579的博客
09-28 1803
mysql报错 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘realname.t_act_coding1.nin_coding’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_grou
MySQL Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column异常处理
Yeats_Liao的博客
04-23 3286
MySQL Expression #2 of 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
baidu_41931697的博客
06-27 561
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
MySQL 报错＞ 1055 -Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated c
qq_43183527的博客
06-30 1562
select * from V$NLS_PARAMETERS NLS_LANG=“SIMPLIFIED CHINESE_CHINA.ZHS16GBK” select * from V$NLS_PARAMETERS 步骤二：在环境变量中添加两条配置信息，鼠标右键我的电脑（计算机/此电脑）等图标，选择属性，选择高级系统设置，选择高级选项卡的环境变量，在系统变量里新建两条配置： 1、LANG=zh_CN.GBK（GBK是这样形式的，不同编码这里的value值需要跟着改变） 2、NLS_LANG=AMERIC
MySQL解决报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column. macbook怎么解决这个报错
12-27
在MySQL中，当使用GROUP BY子句对结果进行分组时，SELECT列表中的列必须要么是分组的列，要么是聚合函数的结果。否则，会出现报错"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"。解决这个报错的方法有两种： 1. 使用聚合函数对非分组列进行聚合操作。 2. 修改MySQL的sql_mode参数，将其设置为非严格模式。 下面是两种解决方法的示例： 方法一：使用聚合函数对非分组列进行聚合操作 ```sql SELECT custname, MAX(salary) FROM your_table GROUP BY custname; ``` 方法二：修改MySQL的sql_mode参数 ```sql SET sql_mode = 'ONLY_FULL_GROUP_BY,NO_AUTO_CREATE_USER'; ``` 请注意，修改sql_mode参数可能会影响其他查询的行为，因此在修改之前请确保了解其影响。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

码农研究僧

你的鼓励将是我创作的动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值