1055 - Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column问题

于 2022-11-11 11:50:11 发布 115 收藏
文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Opticalproperti/article/details/127803563
版权

今天在处理sql 的时候mysql报了这个错误，我使用的是mysql 5.8
最后经过排查发现问题。

在关联 JOIN 表的时候，需要关联字段主键id，则可以正常运行！

Opticalproperti
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
  • 打赏
    打赏
  • 0
    评论
解决Mysql：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
qq_39954916的博客
09-06 1万+
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 日期,活跃度; 以上代码运行报错.
＞ 1055 - Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘h
爱驹一族的博客
06-14 578
完整报错 原因： MySQL 5.7.5和up实现了对功能依赖的检测。如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测到功能依赖项，only_full_group_by在默认情况下是不启用的。关于前5.7.5行为的描述，请参阅MySQL 5.6参考手册。) 聚合列的方式 将报错的字段用MAX（）函数括起来（注意空格
1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘OMO
qq_51853681的博客
12-20 354
今天学习MySQL分组查询遇到一个错误 本人英语不行，只能上百度翻译 虽然还是看不太懂，但大概是说，在group by子句后面缺少了job_id的字段，因为前面用到了聚合函数，所以选择的列必须是分组的列，所以只要在group by 子句后面加上字段就解决了 ...
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_41934715的博客
01-01 320
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
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column报错
每天进步一点点...
11-17 1108
在MySQL语法GroupBy时报错 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db1.product.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by,
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘rea
weixin_43798579的博客
09-28 698
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 #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
泗水六年的博客
10-29 1083
错误1： mysql： select * ,count(*)as count from app_cash_trans_log group by app_cash_trans_log.tran_code having count(*)>=(select pla_config.cfg_value from pla_config where pla_config.cfg_name='tranMaxContinuity') order by app_cash_trans_log.id desc limit 5
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated 【已解决】
最新发布
JavaPub
08-30 174
然后重新运行语句，就可以正常查询了。在MySQL下输入如下语句。
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column...
weixin_44258947的博客
12-15 1080
使用group by分组查询全部字段时报错 SELECT * FROM t_pc_rights_acquire GROUP BY product_id; 解决方法： select查询的字段必须是group by后面的字段product_id，使用聚合函数max/min/avg/count等包裹字段使用。 如以下sql都能正常查询： SELECT product_id FROM t_pc_rights_acquire GROUP BY product_id; SELECT count(id), p
mysql报错 ＞ 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
weixin_44013783的博客
08-05 6851
数据库查询时报错 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘dkia_quality_db.b.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 先说产生这个
mysql报错解决： 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
危险、的博客
01-25 2221
报错如下： 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 incompatible with sql_mode=only_full_group_by 问题出现的原因： MySQL 5.7.5及以上功
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cre
weixin_43085797的博客
04-14 6349
sql语句 SELECT * FROM t_company_change_log WHERE company_id='257949626441666560' AND rec_status='N' GROUP BY change_item 这样会在某些版本的数据库中运行出错 原因是 5.7.5之后版本默认启用了only_full_group_by SQL模式，所以MySQL会不识别选择列表...
mysql报错1200_Mac MySql8报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains n...
weixin_29083373的博客
02-18 168
报错信息：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 ...
MySQL报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colu
JaneYork的博客
02-17 5483
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 #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gra
qq_42384506的博客
04-23 394
报错内容： 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'graduate.score.score_id' which is not functionally dependent on columns in GROUP BY clause; this...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
©️2022 CSDN 皮肤主题：深蓝海洋 设计师：CSDN官方博客 返回首页
评论

打赏作者

Opticalproperti

你的鼓励将是我创作的最大动力

¥2 ¥4 ¥6 ¥10 ¥20
输入1-500的整数
余额支付 (余额：-- )
扫码支付
扫码支付：¥2
获取中
扫码支付

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

打赏作者

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

抵扣说明：

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

余额充值