[Mysql 报错] 解决MySQL：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nona

最新推荐文章于 2024-09-09 10:22:25 发布
最新推荐文章于 2024-09-09 10:22:25 发布
阅读量1.8k 收藏
点赞数
分类专栏： 工作BUG相关 工作总结相关 文章标签： sql
汤圆
本文链接：https://blog.csdn.net/sqL520lT/article/details/120566395
版权

原因:

MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY
SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用在GROUP BY子句中既未命名的非集合列，也不在功能上依赖于它们。（5.7.5之前，MySQL没有检测到功能依赖关系，默认情况下不启用ONLY_FULL_GROUP_BY。有关5.7.5之前的行为的说明，请参见“MySQL5.6参考手册”。）

先查询配置信息:

select @@global.sql_mode;


#原本数据
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION


                 修改过后的数据。 少了一个   ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

使用这个语句:
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';

是汤圆丫
关注
专栏目录
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
码农研究僧的博客
04-24 1655
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 302
经过查询资料发现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，去掉即可。
ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregate
weixin_44957344的博客
01-08 1157
执行sql语句报错： ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘test.fruits.f_id’ which is not functionally dependent on columns in GROUP BY cl...
MySql报错only_full_group_by的解决办法
最新发布
qq_37639246的博客
09-09 601
前段时间我在一个新环境里部署程序时遇到MySql报错only_full_group_by，之前已经遇到过一次同样的问题，当时没有总结经验，导致这次解决时耗费了不少时间，这里把本次的处理过程进行记录总结，同时分享给大家MySql数据库报错如下，从字面意思理解是select后面查询的字段没有出现在group by中MySql在低版本（5.7.x以下）中允许select后面的非聚合列不出现在group by中。以下sql在低版本中是可以运行的，但是在5.7及以上版本会报错。
解决Mysql在分类查询时报1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre...
if's Blog
06-10 598
mysql报错 1055 前言 参考CSDN博主「心肝宝贝甜蜜饯儿」https://blog.csdn.net/loveliness_peri/article/details/88051316 参考简书博主[东西汉] https://www.jianshu.com/p/3a4185923963 错误描述 [Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
qq_43227967的博客
03-30 7953
错误信息： [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
apple_51718389的博客
02-19 532
本人SQL从业者实践实测，问题sql_mode问题 解决问题三步法： 1.找到我得电脑找到配置文件my_ini文件； 2.将代码：sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION复制到my_ini文件 3.如图问题解决 ...
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`子句中...
Mac MySql8报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated
Jack_Tpy的Java学习之旅
07-28 849
报错信息： 1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘fbjs.mscc.ContactTime’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Time: 0
解决MySQL报出1055-Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated类型的错误
weixin_45775973的博客
07-29 4156
在Mysql（版本为8.0.25）中进行分组查询的时候，频繁报出如下的错误：
mysql报错 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
我心坚持
05-11 394
进入到mysql界面；输入以下代码： SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_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---之严格模式详解
weixin_45932995的博客
12-07 830
严格模式参数详解： 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 c
qq_43183527的博客
06-30 1489
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
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘rea
weixin_43798579的博客
09-28 1756
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
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_41934715的博客
01-01 873
MARK 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'student.b.C_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Time: 0.00200
解决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：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; this is incompatible with sql_mode=only_full_group_by 。 引用:这个错误是由于 MySQL 的新版本中默认开启了ONLY_FULL_GROUP_BY模式，即在 GROUP BY 语句中的 SELECT 列表中，只能包含分组或聚合函数，不能包含其他列。而你的查询语句中出现了一个列senior_two.score.student_id，它既没有被分组也没有被聚合，因此 MySQL 报出了这个错误。 。 引用:如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测...。 根据引用，这个错误意味着在SELECT语句中的第二个表达式不在GROUP BY子句中，并且包含了一个非聚合的列'senior_two.score.student_id'。这与sql_mode=only_full_group_by模式不兼容。 根据引用，这个错误是由于MySQL的新版本中默认开启了ONLY_FULL_GROUP_BY模式。在GROUP BY语句的SELECT列表中，只能包含分组或聚合函数，不能包含其他列。而你的查询语句中出现了一个列'senior_two.score.student_id'，它既没有被分组也没有被聚合，因此MySQL报出了这个错误。 如果你启用了only_full_group_by SQL模式（默认情况下是启用的），那么MySQL会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *2* [1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘se](https://blog.csdn.net/m0_61615803/article/details/130076452)[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^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] - *3* [解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains ...](https://download.csdn.net/download/weixin_38743076/13698627)[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^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

打赏作者

是汤圆丫

怎么 给1分?

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

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

打赏作者

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

抵扣说明：

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

余额充值