MySQL： 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column

最新推荐文章于 2024-01-17 09:26:17 发布
最新推荐文章于 2024-01-17 09:26:17 发布
阅读量276 收藏
点赞数
分类专栏： 性能优化 文章标签： sql mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44040505/article/details/103927868
版权

MySQL： 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column

错误愿意大概是：SELECT 的字段列表没有包含在 GROUP BY 语句中

很多年之前都用的好好的，怎么就报错了呢！！！！

查了一下，哦，这又是 MySQL 5.7 的锅。

优化代码，剔除 select 语句中的多余字段，也就是不要触发 only_full_group_by。这是值得推荐的，因为这是写出好代码的必要添加之一。

告诉系统，你可以随意返回值，也就是使用 any_value() 函数来包装值

如果你必须要出现这个字段，那么这是推荐的方式

n梦冰
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
MySQL报错1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
Ariel_欢
05-15 5652
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 解决方法
F7ANTY的专栏
12-29 9852
1、问题复现： 　　今天在进行数据迁移时，使用Navicat连接数据库进行连接时，由于 SQL语句中使用了 group by分组函数，结果报了如下错误： 2、产生原因 　　产生原因说是，在MySQL数据库版本为5.7以上的版本，默认开启了ONLY_FULL_GROUP_BY SQL模式，在此模式下，对于group by操作,如果在select语句中的查询列没有在group by中出现，那么这个SQL就是非法的，因为列不在group by语句中，所以设置了sql_mode=only_full_gr.
MySQL报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colu
热门推荐
JaneYork的博客
02-17 1万+
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 incom...
1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘mys
milayz的博客
06-02 503
在MySQL使用group by时会出现错误，：
mysql报错1200_Mac MySql8报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains n...
weixin_29083373的博客
02-18 419
报错信息：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 ...
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
12-15
如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测...
MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
12-14
[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP ...
mysql遇到Expression.docx
03-05
mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
MySQL使用中遇到的问题记录
12-15
#1 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by 解决办法 # 设置正确的 sql_mode 即可解决 # 登陆MySQL ...
mysql5.7以上报错：Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
hhq850741642的博客
09-29 744
在写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
1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘OMO
qq_51853681的博客
12-20 661
今天学习MySQL分组查询遇到一个错误 本人英语不行，只能上百度翻译 虽然还是看不太懂，但大概是说，在group by子句后面缺少了job_id的字段，因为前面用到了聚合函数，所以选择的列必须是分组的列，所以只要在group by 子句后面加上字段就解决了 ...
【MySQL】报错1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated
weixin_61428498的博客
08-01 175
1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum完美解决！！！！！
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
二十一克阳光！的博客
12-05 981
在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...
MySQL[Err] 1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated
好幸运
10-28 361
原因：数据库版本问题，本地5.7.12-log，服务器5.7.27 解决方法： 1.找到数据库的my.ini文件（my.cnf） 2.在[mysqld] 字段下添加 sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_...
mysql报错115_mysql报错Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated ...
weixin_32340873的博客
01-30 814
今天sql一对多关联查询发现一个错误，提示说查询的字段不在group by的子句中，因为sql_mode是only_full_group_by。报错信息：#1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xt_sc.t_comment.content' ...
Mysql1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated问题报错
weixin_43822858的博客
03-05 250
今天写sql分组查询的时候报了这么个错，网上查解决办法都是改 @@global.sql_mode。如： 但是不知道什么原因(可能是因为我下载的是免安装版？)，我改了之后group分组还是报上面的错误。 都准备放弃了，准备接着往后写，突然发现了问题所在==||； 先说解决方法吧(其实也不算解决方法吧)，免得大家着急：) 在你按某字段分组的时候，其他字段每一列的值可能不同，比如下图所示的表： 此时运行sql语句： SELECT id from test GROUP BY area; 就会报标题所示错误。
mysql5.7以上报错：1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated
最新发布
北极的企鹅
01-17 519
mysql5.7以上报错：1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated
#1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this i
大道至简，持之以恒！
01-11 9377
#1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this i
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、付费专栏及课程。

余额充值