mysql Expression #1 of SELECT list is not in GROUP BY

最新推荐文章于 2024-08-09 12:44:01 发布
最新推荐文章于 2024-08-09 12:44:01 发布
阅读量155 收藏
点赞数
分类专栏： 问题
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44195175/article/details/106193495
版权

出现这个错误 可以用 mysql>select @@sql_mode; 查看@@sql_mode 是否包括了ONLY_FULL_GROUP_BY这个模式

  • 只在当时有效 SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

  • 永久有效需要更改配置文件, linux 在/etc/my.cnf , windows在my.ini 设置(没有ONLY_FULL_GROUP_BY 后的select @@sql_mode;结果)

    • sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
YZBPXX
关注
专栏目录
mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DN金猿的博客
06-28 277
经过查询资料发现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 1563
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
解决 idea报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
weixin_43864927的博客
01-09 894
idea报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 写了一个查询语句执行的时候，idea日志报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 在Navicat中执行也会报这个...
mysql：报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonag
欢迎来到 ABin-阿斌的博客：写一生代码，创一世佳话，筑一览芳华。
05-24 1150
声明： 原文作者【CSDN】：lankun66 原文地址：https://blog.csdn.net/qq_44625080/article/details/104043682 前言 最新在开发中遇到了一个问题，就是在代码书写中我用了 GroupBy做去重处理。在开发环境测试是好的，但是发布到测试就报了如下错误。 报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 后来问运维兄弟才知道：测试环境
完美MySQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column的解
最新发布
科技改变人类，技术成就未来
08-09 1406
在使用 MySQL 时，可能会遇到这样的错误提示：“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column”。这通常是由于在 GROUP BY 查询中，SELECT 列表中的某些列没有被包含在 GROUP BY 子句中或没有使用聚合函数所导致的。本文将详细介绍这一错误的原因，并提供相应的解决方法。
Expression #1 of SELECT list is not in GROUP BY clause and xxxx sql_mode=only_full_group_by
GalenGao
07-17 344
异常描述 公司的老项目代码拿到本地启动的时候，mysql 报了以下错误： Caused by: org.hibernate.exception.SQLGrammarException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'framework_mj.agile_board_star.id' which is not functionally dependent on
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxxx
Jack魏
09-09 978
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.原...
myql报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
IT大神帅杰的博客
05-24 400
myql报错 Expression #1 of 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`子句中...
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
09-09
如果`SELECT`列表中的列没有出现在`GROUP BY`子句中，且该列没有被聚合函数（如`SUM`, `AVG`, `MAX`, `MIN`等）处理，MySQL会抛出`Expression #1 of SELECT list is not in GROUP BY clause and contains ...
MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法
m0_52789121的博客
06-07 1297
今天使用mysql简单的一句分组查询语句（GROUP BY）报错了。 查了问题原因和解决方法，成功解决。原因：使用GROUP BY 语句违背了sql_mode=only_full_group_by。因为mysql版本5.7之后默认的模式是ONLY_FULL_GROUP_BY。官网文档的原话： 说人话，大概意思就是说（使用google翻译）：1、先使用SQL查询sql_mode 2、重新设置sql_mode，删除ONLY_FULL_GROUP_BY 3、退出重进 再次执行查询语句，...
mysql sql查询拼上group by问题
weixin_37692315的博客
06-09 134
报错日志： #Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #57 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘gbw.gs.ID’ which is not functionally dependent on columns in GROUP BY clause; this is incom
报错：Expression #1 of SELECT list is not in GROUP BY .......with sql_mode=only_full_group_by
m0_46420991的博客
06-03 170
报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘hospital.d.rugstoreId’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 解决方案： 在MySQL执行下列语句
MySQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xx
热门推荐
健身变秃，coding变强
04-29 1万+
MySQL group by报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.test_baobiao.qty' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
MySQL报错： Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
陈一一同学的博客
06-21 2737
MySQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zx_ds.biz_table_ver.ver_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n### ....
Expression #1 of SELECT list is not in GROUP BY错误
余_小凡 的博客
12-20 1073
GROUP BY，mysql5.7升级到mysql5.8
Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY
zhanghua0324的博客
04-24 2750
在使用MySQL5.7.32 分组查询出现Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY 出错原因：MySQL 5.7及以上功能依赖检测功能，如果启用了ONLY_FULL_GROUP_BY SQL 模式（默认情况下），MySQL将拒绝选择列表，HAVING 条件或 ORDER BY 列表的查询引用在 GROUP BY 子句中既未命名的非集合列，也不在功能上依赖于它们。 ..
MySQL解决报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
weixin_59633478的博客
12-09 594
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rent.menu.id' 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【bug】解决方案
qq_42265220的博客
03-29 1416
问题场景： select stuid from student_table GROUP BY stuAccount HAVING count(stuAccount)>1; 运行完这条sql语句后mysql就报了这个错误。 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column… 解决方案： 1.对于已经存在的数据库 执行下面的sql语句即可（没有效果重启数据库服务） SE
Expression #1 of SELECT list is not in GROUP BY
09-22
引用和引用[2]提到了一个错误信息"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated"。这个错误通常发生在MySQL中，当使用GROUP BY子句对结果进行分组时，SELECT列表中的列没有...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值