mysql5.7使用gropu by报错问题的解决 Expression #1 of SELECT list is not in GROUP BY clause and contains nona

最新推荐文章于 2024-07-29 23:30:00 发布
最新推荐文章于 2024-07-29 23:30:00 发布
阅读量391 收藏
点赞数
分类专栏： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44255568/article/details/108669989
版权

  1. 问题：今天在msql5.7客户客户端上执行带有gruop by 语句的时候发生了如下错误

  2. 在这里插入图片描述

  3. 解决办法：
    （1）先执行如下sql命令

select @@global.sql_mode;

在这里插入图片描述
(2). 打开mysl 的配置文件 my.ini 文件，需要根据自己上一步操作后的 结果1 中的内容复制出来，并去掉第一个参数项，就可以就进行如下配置了

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

在这里插入图片描述
（3） 保存my.ini 文件后，重启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 BY clause; this is incompatible with sql_mode=only_full_group_by 在navicat中使用mysql加索引或者删除索引时报了这个错。 两种解决方
mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
热门推荐
N-SOKACH的博客
09-19 18万+
报错如下： 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 incompat
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘inform
最新发布
weixin_54048131的博客
07-29 268
【代码】Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘inform。
MySQL 报错 ：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
Stefan的博客
07-01 4204
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cheyintongdemo.a
MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”
qq_18839693的博客
02-14 2111
MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre” 执行SQL: SELECT login_name,login_ip,sex FROM tank_admin GROUP BY login_name ; 这个sql语句违背了sql_mode=only_full_grou
groupby报错not dependent on columns in GROUP BY clause； this is incompatible with sql_mode=only_full
write less , do more
05-09 8464
MySQL执行如下group by 语句报错：1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'table_zjq.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
MySQL group by是如何使用索引的？
yasinshaw的博客
05-29 9294
点击↑上方↑蓝色“编了个程”关注我~这是Yasin的第 64 篇原创文章最近的文章都是用的自己拍的照片。住的地方附近有个小花园，今天下了点雨，下午去花园散步的时候觉得上面的露珠很漂亮，就顺手拍了一张。现在的年轻人生活都太忙碌，很少有时间去仔细观察大自然的美。但有时候停下来看看，可能内心会平静一些，聚焦当下，烦恼会少一点，快乐会多一点。前两天项目上有一个查询的需求，需要用到...
关于数据库MySQL中group by的用法
muweichang的博客
08-23 465
从英文的字面意思上理解：根据（by)一定的规则进行分组(group). 定义：通过一定的规则将一个数据集划分成若干个小的区域，然后针对若干个小区域进行数据处理
pandas dataframe 分组操作gropu by时如何按照原表格的顺序group by
04-19
可以使用pandas中的"pd.Categorical"将列转化为有序分类，然后按照这个分类进行group by操作。具体实现步骤可以参考以下代码： ```python import pandas as pd # 生成一个DataFrame样例 df = pd.DataFrame({'A':[1...
[Hive基础]--Where and Having
欢迎来到我的博客，一起探索代码里的世界！
09-13 1万+
Where 和Having的区别？   1、相同点 where和having：都是限定返回的数据集、 在一个sql语句中可以有where子句和having子句。 2、不同点 where (1)在where 子句中不能使用聚组函数 -- 错误的写法 SELECT rd.brand_id from table001 rd group by rd.brand_id where rd....
【MySQL】Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
孜蓝的博客
10-22 215
1.登录MySQL 打开cmd，输入： mysql -uroot -p 回车后输入密码，即进入 2. 更改global.sql_mode 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_
mysql分组查询出现错误:Expression #1 of SELECT list is not in GROUP BY clause and contains nonagg
weixin_50596156的博客
03-10 3176
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启用了ONLY_FULL_GROU
MySQL报Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
离阳的博客
03-25 269
mysql5.7在使用group by子句时，会遇到如下问题: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 聚合查询出现这样的报错是因为mysql设定的mode含有 ONLY_FULL_GROUP_BY MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值