mysql5.7: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre

最新推荐文章于 2025-03-04 15:47:21 发布
转载 最新推荐文章于 2025-03-04 15:47:21 发布 · 625 阅读 · 0 ·
CC 4.0 BY-SA版权
原文链接：http://flask.frankway.net/post/1359
文章标签：

#mysql

本文介绍如何在MySQL中禁用only_full_group_by特性，通过修改sql_mode来确保查询的兼容性和灵活性。设置全局和会话级别的sql_mode，避免因only_full_group_by导致的查询错误。

去掉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_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’;

mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DN金猿的博客
06-28 1323
经过查询资料发现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 nonaggre”解决方法
热门推荐
lucky多多的博客
03-22 5万+
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 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 nonaggregated column错
爱媳妇儿爱编程
11-01 1340
mysql 升级版本出现experssion #2 ONLY_FULL_GROUP_BY错误问题解决
MySQL SyntaxErrorException SELECT list is not in GROUP BY 报错解决
C_V_Better的博客
03-04 850
错误是由于 MySQL 的模式引起的。通过修改 SQL 查询、修改 MySQL 配置或使用聚合函数，可以解决这个问题。在实际开发中，建议根据具体需求选择合适的解决方法。
MYSQL---之严格模式详解
weixin_45932995的博客
12-07 1109
严格模式参数详解： 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出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre错误
weixin_48842132的博客
03-05 1703
是由MySQL 5.7.5后only_full_group_by成为sql_mode的默认选项之一，导致了一些sql语句的失效产生的。本文提供了两种解决方法。
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
09-09
如果`SELECT`列表中的列没有出现在`GROUP BY`子句中，且该列没有被聚合函数（如`SUM`, `AVG`, `MAX`, `MIN`等）处理，MySQL会抛出`Expression #1 of SELECT list is not in GROUP BY clause and contains ...
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
河静
11-12 488
mysql表结构如下： mysql> select * from fruits ; +------+------+------------+---------+ | f_id | s_id | f_name | f_price | +------+------+------------+---------+ | a1 | 101 | apple | 5.20 | | a2 | 103 | apricot | 2.20 | | b1 | 101 |
MySQL问题解决：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
whale的博客
01-08 4008
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 中出
mysql分组时出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre
Smilelfq的专栏
01-28 914
报错： 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 nonaggregated colum
weixin_44525558的博客
06-22 2951
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated colum 原因： MySQL 5.7.5及以上默认对功能依赖的检测。如果启用了only_full_group_by SQL模式，MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。 select @@global.sql_mode 出现： ONLY_FULL_GROUP_BY,S
mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
CharlesYooSky的博客
04-10 324
mysql产生的异常： 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; this is incom...
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
二十一克阳光！的博客
12-05 1056
在mysql中使用 group by 出现的问题 ERROR 1055 (42000): Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘ynn.goods.goods_id’ which is not functionally dependent on column...
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
weixin_45626288的博客
03-29 3351
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
mysql遇见Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre问题解决
最新发布
06-04
如果违反这一规则，就会出现类似`Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column`的错误。 以下是解决此问题的详细方法： --- ### 解决方案 #### 方法一：修改SQL...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值