mysql 使用group by 查询报以下错误1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

最新推荐文章于 2023-04-11 09:44:50 发布
最新推荐文章于 2023-04-11 09:44:50 发布
阅读量472 收藏
点赞数
分类专栏： 数据库 文章标签： mysql group by
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/con_knife/article/details/80301661
版权

根据网上一些说法是版本原因

直接在mysql配置文件中添加以下代码即可，配置文件中 如果存在 [mysqld] 则可以省略掉，直接滚动到最后添加

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

运行命令

 service mysql restart
con_knife
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DN金猿的博客
06-28 167
经过查询资料发现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，去掉即可。
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
最新发布
码农研究僧的博客
04-24 1242
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
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘temp.summa
乐杨俊浅谈LAMP
09-08 131
目录 1-MySQL执行SQL报错 2-错位原因 3-问题解决 一：临时修改生效 二：永久生效 1-MySQL执行SQL报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'temp.summary_date' which is not functionally dependent on columns in GROUP BY clause; this is in
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.
热门推荐
fansili的博客
11-29 8万+
安装了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 GR
Mysql Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xx‘
m0_50176078的博客
09-09 573
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column报错
每天进步一点点...
11-17 1883
在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 #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tab
徊忆羽菲
01-06 2514
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'table1.sale_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible...
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...
weixin_43697366的博客
06-08 620
今天接口突然返回这个错误： 因为一直使用的是阿里云 rds实例，之前接口返回正常，没有更新过代码，因为最近重新购买了该实例rds,所以问题定位到这个上边，后来查询是mysql的配置是默认了参数的sql_mode=only_full_group_by MySql在低版本（5.7.x以下）中允许select后面的非聚合列不出现在group by中。以下sql在低版本中是可以运行的，但是在5.7及以上版本会报错 通过该命令查询：SELECT @@sql_mode 解决方法就是在对应rds实例化的.
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.
weixin_40925480的博客
11-03 1090
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.
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`子句中...
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...原因及解决方案
江海寄余生的博客
03-30 1万+
最近公司新建了一个项目，在项目中需要用到group by进行聚合计算，在计算的同时也要查出一些其他字段来返回给前端。于是就有了这个错误的出现。 先简单复现我所写的sql，其实sql非常简单。 select channel_name as channelName, brand_name as brandName, sum(actual_value) as actualValue, sum(actual_value_ty) a
MySQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xx
weixin_56749167的博客
11-25 690
MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘se
m0_61615803的博客
04-11 7165
模式，即在 GROUP BY 语句中的 SELECT 列表中，只能包含分组或聚合函数，不能包含其他列。而你的查询语句中出现了一个列。列加入 GROUP BY 列表中，这样 MySQL 就能知道如何处理这个列了。这个查询将按学生 ID 分组，并计算每个学生的平均分。这样 MySQL 就不会报出上述错误了。，它既没有被分组也没有被聚合，因此 MySQL 报出了这个错误。这个错误是由于 MySQL 的新版本中默认开启了。Navicat Premium 16 版本。
myql报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
IT大神帅杰的博客
05-24 391
myql报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxxx
Jack魏
09-09 969
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'music_partner.m.id' which is 1. 把你要分组的字段设置成设成primary key 或者 unique NOT NULL。2.关闭sql_mode=ONLY_FULL_GROUP_BY3.原...
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo
bug如沙 , 汇成撒哈拉
09-21 1万+
          说明情况: 首先我是在Linux服务器上新装了一个mysql , 原先版本为5.7.22 , 现在不小心装成了5.7.16 , 项目启动是时候跳转首页不显示数据 , 后台开始报错 :           如下 , 具体错误bug忘了复制截图 , 只保留了标题和下面这两行百度的内容 , 属于bug原因  Expression #1 of ORDER BY clause is ...
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘
学习使我快乐_玉祥
12-30 180
使用命令行进入mysql数据库，需要有super权限，执行如下语句，即可解决问题。
【Mysql】报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
winrh的博客
02-10 535
【Mysql】报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xxx’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column
07-27
回答: 当使用GROUP BY语句进行查询时，SELECT语句中只能包含GROUP BY后面声明的列或者聚合函数。这是因为MySQL的ONLY_FULL_GROUP_BY模式要求SELECT语句中的列必须是明确的，以确保分组求最值的合法性检查。这种模式采用了与Oracle、DB2等数据库的处理方式。因此，如果在GROUP BY语句中使用了聚合函数，就需要将SELECT语句中的列限制在GROUP BY后面声明的列或者聚合函数中。如果SELECT语句中出现了不明确的列，就会报错"SELECT list is not in GROUP BY clause and contains nonaggregated column"。\[1\]\[2\]\[3\] #### 引用[.reference_title] - *1* [mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.](https://blog.csdn.net/weixin_40925480/article/details/127680083)[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^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] - *2* *3* [mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column......](https://blog.csdn.net/weixin_37557729/article/details/123896433)[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^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值