Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregate

最新推荐文章于 2024-09-08 19:42:24 发布
最新推荐文章于 2024-09-08 19:42:24 发布
阅读量1k 收藏
点赞数
分类专栏： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/RodJohnson_523391/article/details/84914324
版权
[url]https://www.cnblogs.com/lonelywolfmoutain/p/5433581.html[/url]

[url]https://stackoverflow.com/questions/36228836/syntax-error-or-access-violation-1055-expression-8-of-select-list-is-not-in-gr[/url]

[url]https://stackoverflow.com/questions/37951742/1055-expression-of-select-list-is-not-in-group-by-clause-and-contains-nonaggr[/url]
浪子骑驴
关注
专栏目录
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
码农研究僧的博客
04-24 1866
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 369
经过查询资料发现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，去掉即可。
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_36627328的博客
04-16 593
原因 出现此问题的原因是 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 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 #1 of SELECT list is not in GROUP BY clause and contains nonaggre解决方法
最新发布
weixin_46949892的博客
09-08 529
原因：在MySQL5.7.5版本之前，这类语句是默认可以执行的，因为默认没有开启ONLY_FULL_GROUP_BY，在此版本之后，MySQL默认开启了此模式，执行此类SQL就会报错了。查询当前MySQL所用的模式配置，拷贝查询结果，然后将其中的ONLY_FULL_GROUP_BY删除掉，然后复制删除后的结果到如下SQL中。查询当前MySQL所用的模式配置，拷贝查询结果，然后将其中的ONLY_FULL_GROUP_BY删除掉，然后复制删除后的结果到如下SQL中。修改MySQL的配置文件：my.ini。
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中的列没
mysql出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre错误
weixin_45032599的博客
01-13 8251
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 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column异常处理
Yeats_Liao的博客
04-23 2884
MySQL Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column异常处理
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`子句中...
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
小白求学进阶
06-11 7566
一、原因 聚合查询出现这样的报错是因为mysql设定的mode含有 ONLY_FULL_GROUP_BY mysql> select @@sql_mode; +------------------------------------------------------------------------------------------------------------...
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘c.countFan
weixin_43802097的博客
05-12 1304
mysql中的sql__@@mode问题， 导致sql无法运行 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c.countFangWenCiShuByToday' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only
mysql遇见Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre问题解决
axiaobaoa的博客
01-06 1万+
解决执行sql语句报错Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxx' which is not functionally dependent on columns in GROUP BY clause;this is incompatible with sql_mode=only_full_group_by
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘learn_mysq
Chrisliuluo的博客
03-27 640
报错原因：mysql的5.7以上版本都默认sql_mode=only_full_group_by，这个规则实际是为了提升查询的性能，因此规定我们在查询的时候只能准确的查找要查的唯一数据，不支持group by的分组条件与select的条件不一致。只能写 select id from tableA group id having id='*6*';这种语句，可以在having中控制模糊匹配，但是查询条件和分组条件必须一致。永久性解决该问题，只需要修改mysql的配置文件，my.cnf文件，添加一行配置。
解决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 日期,活跃度; 以上代码运行报错.
mysql分组时出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre
Smilelfq的专栏
01-28 881
报错： 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
mysql5.7: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre
taommmm的博客
08-30 589
去掉only_full_group_by set global sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’; set session sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_
MySQL问题解决：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
whale的博客
01-08 3892
MySQL问题解决：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 问题还原：某次系统数据库迁移，配置了新的服务器作为mysql数据源，数据和原来的数据库保持一致； 结果：项目部署成功后group by 相关的sql语句报错，见标题。 原因： MySQL 配置中 sql_mode 默认配置了only_full_group_by，这样的话需要 GROUP BY 中包含所有 在 SELECT 中出
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
07-29
引用\[1\]、\[2\]和\[3\]都是关于MySQL报错的信息，其中提到了"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"的错误。这个错误是由于在使用GROUP BY子句进行分组查询时，SELECT列表中的某些列没有在GROUP BY子句中出现，并且这些列也没有被聚合函数包含，导致不兼容的错误。这个错误通常是由于MySQL的sql_mode设置为only_full_group_by引起的。解决这个错误的方法是要么将SELECT列表中的列添加到GROUP BY子句中，要么将这些列用聚合函数进行处理，以确保查询的正确性。 #### 引用[.reference_title] - *1* *3* [MySQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ...](https://blog.csdn.net/Saintmm/article/details/124491860)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v4^insert_chatgpt"}} ] [.reference_item] - *2* [Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre](https://blog.csdn.net/weixin_44051060/article/details/105602832)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v4^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值