mysql5.7以上报错：1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated

原创 于 2024-01-17 09:26:17 发布 · 769 阅读 · 9 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated

报错信息

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

临时修改

解决办法：
#1、先 select @@global.sql_mode; 查询是否包含 ONLY_FULL_GROUP_BY值。
#2、设置方法：
set @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVIS
最低0.47元/天 解锁文章
mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DN金猿的博客
06-28 1361
经过查询资料发现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报错1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
Ariel_欢
05-15 6930
1.问题描述： 今天在写SQL语句时，需要将数据先按用户分组汇总，再按物品类型（测试数据库中字段是item_name）进行分组汇总，SQL语句中使用了group by分组函数，然后执行SQL报错： 执行的SQL语句： SELECT a.user_id,a.item_name,a.item_id,a.approver_id,a.create_time,a.supposed_return_time FROM `t_approval` as a WHERE now() > a.supposed
【MySQL】报错1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated
weixin_61428498的博客
08-01 663
1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum完美解决！！！！！
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘c.countFan
weixin_43802097的博客
05-12 1376
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报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
qq_34957299的博客
08-31 861
产生原因说是，在MySQL数据库版本为5.7以上的版本，默认开启了 ONLY_FULL_GROUP_BY SQL模式，在此模式下，对于group by操作,如果在select语句中的查询列没有在group by中出现，那么这个SQL就是非法的，因为列不在group by语句中，所以设置了sql_mode=only_full_group_by的数据库，在使用group by时就会报错。除了上面的手动设置sql_mode值之外，还可以在 MySQL 的配置文件中进行设置。今天在进行数据迁移时，使用。
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
09-09
且该列没有被聚合函数（如`SUM`, `AVG`, `MAX`, `MIN`等）处理，MySQL会抛出`Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated`错误。这个问题在5.7版本之前并不严格检查，但在...
1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘mys
milayz的博客
06-02 631
在MySQL使用group by时会出现错误，：
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column
程序员阿坤的博客
05-03 5523
"Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'workflow.s.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with s...
mysql not in报错_MySQL报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains non...
weixin_42613583的博客
02-07 220
1、问题复现：今天在进行数据迁移时，使用Navicat连接数据库进行连接时，由于 SQL语句中使用了 group by分组函数，结果报了如下错误：2、产生原因产生原因说是，在MySQL数据库版本为5.7以上的版本，默认开启了ONLY_FULL_GROUP_BY SQL模式，在此模式下，对于group by操作,如果在select语句中的查询列没有在group by中出现，那么这个SQL就是非法的...
mysql报错1200_Mac MySql8报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains n...
weixin_29083373的博客
02-18 774
报错信息：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 ...
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
二十一克阳光！的博客
12-05 1058
在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...
Mysql1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated问题报错
weixin_43822858的博客
03-05 362
今天写sql分组查询的时候报了这么个错，网上查解决办法都是改 @@global.sql_mode。如： 但是不知道什么原因(可能是因为我下载的是免安装版？)，我改了之后group分组还是报上面的错误。 都准备放弃了，准备接着往后写，突然发现了问题所在==||； 先说解决方法吧(其实也不算解决方法吧)，免得大家着急：) 在你按某字段分组的时候，其他字段每一列的值可能不同，比如下图所示的表： 此时运行sql语句： SELECT id from test GROUP BY area; 就会报标题所示错误。
异常Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column的解决方法
weixin_46715521的博客
11-08 675
mysql语句执行报错的解决方法
运行报错Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column xx....
爱码士的博客
02-01 1735
安装了mysql5.7，用group by 查询时抛出如下异常： Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘userinfo.t_long.user_name’ which is not functionally dependent on columns in ...
1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘OMO
qq_51853681的博客
12-20 755
今天学习MySQL分组查询遇到一个错误 本人英语不行，只能上百度翻译 虽然还是看不太懂，但大概是说，在group by子句后面缺少了job_id的字段，因为前面用到了聚合函数，所以选择的列必须是分组的列，所以只要在group by 子句后面加上字段就解决了 ...
mysql5.7以上报错：Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
hhq850741642的博客
09-29 915
在写sql时报错信息：1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘pms.ru.role_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byselect @@glo
mysql:Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_23157491的博客
02-24 657
解决方法：set @@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：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 &#39;senior_two.score.student_id&#39; 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子句中，并且包含了一个非聚合的列&#39;senior_two.score.student_id&#39;。这与sql_mode=only_full_group_by模式不兼容。 根据引用，这个错误是由于MySQL的新版本中默认开启了ONLY_FULL_GROUP_BY模式。在GROUP BY语句的SELECT列表中，只能包含分组或聚合函数，不能包含其他列。而你的查询语句中出现了一个列&#39;senior_two.score.student_id&#39;，它既没有被分组也没有被聚合，因此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 ]
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值