解决Mysql：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated

最新推荐文章于 2025-06-28 23:07:19 发布
原创 最新推荐文章于 2025-06-28 23:07:19 发布 · 5.3k 阅读 · 14 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql #数据库 #oracle

最低0.47元/天 解锁文章

200万优质内容无限畅学
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
码农研究僧的博客
04-24 2949
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 969
然后重新运行语句，就可以正常查询了。在MySQL下输入如下语句。
MYSQL---之严格模式详解
weixin_45932995的博客
12-07 996
严格模式参数详解： 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...
ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregate
最新发布
weixin_51288065的博客
06-28 329
这个错误是由于 MySQL 的sql_mode中包含规则导致的，它要求，或者这些列必须（即存在函数依赖关系）。
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
weixin_45626288的博客
03-29 3317
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wsq.m.chat_room_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL 错误 [1055] [42000]: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggreg
quanqxj的博客
01-15 7478
在使用group by时，报错信息如下： ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mome.a.type' which is not functionally dependent on columns in GROUP...
【MySQL】报错1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated
weixin_61428498的博客
08-01 625
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
在MySQL中，错误提示 "[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column…” 指的是在执行包含`GROUP BY`子句的查询时，你试图对未在`GROUP BY`子句中...
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 #2 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
热门推荐
Hi_alan的博客
07-19 1万+
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xxxx’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 查阅资料发现，对于group by聚合操作,如果在select中的列没
报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
Ai_Answer_zr的博客
01-02 1025
2023-4-26：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
MySQL Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column异常处理
Yeats_Liao的博客
04-23 3338
MySQL Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column异常处理
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘rea
weixin_43798579的博客
09-28 1808
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 nonaggre
Smilelfq的专栏
01-28 895
报错： Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wlhy.c.com mysql分组时出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre 在mysql里面执行命令 SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONL
mysql Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre
Orient的博客
10-21 1万+
一，问题现象 在mysql中，用group by 分组时 报错Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre，运行的sql select a.id, a.name, a.age from a group by id, name 这个主要是违背了mysql开启的校验only_full_group_by 检测 二，问题的本质 这个问题主要是mysql 开启了onl...
mysql出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre错误
weixin_45032599的博客
01-13 8649
1、问题原因 mysql为5.7之前，则会默认启用ONLY_FULL_GROUP_BY SQL模式，MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用在GROUP BY子句中既未命名的非集合列，也不在功能上依赖于它们。 2、解决方法 1、第三方视图工具（Navicat） select @@global.sql_mode 使用sql查询出结果后，一般情况会出现ONLY_FUL...
Mysql：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
08-25
引用:1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'senior_two.score.student_id' which is not functionally dependent on columns in GROUP BY clause;...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值