SQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause异常处理

于 2025-02-16 14:42:06 发布
阅读量233 收藏 3
点赞数 6
分类专栏： # mysql 数据库 文章标签： python 开发语言
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43811057/article/details/144718095
版权

SQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause异常处理


异常详细日志如下 

2024-12-25 10:31:50.945 ERROR [69a1c5e7c28d642ba83871566818f352] [http-nio-9627-exec-8] c.z.i.a.m.c.IamauthmgtExceptionHandler.exceptionHandler:47 - 错误消息:
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated col
最低0.47元/天 解锁文章
多种方法解决Error querying database. Cause: java.sql.SQLException: No value specified for parameter 1
念兮为美
02-18 1万+
多种方法解决Error querying database. Cause: java.sql.SQLException: No value specified for parameter 1
mysql(全版本) - 报错 Expression 1 of ORDER BY clause is not in SELECT list,references column（详细解决教程）
最新发布
高级前端工程师
04-13 3971
mysql，linux，centos，数据库，报错，出现错误，mysql升级版本报错，MYSQL更新版本后出现报错，数据库升级后都报错了，mySQL升级后都报错了，详细解决方案，Expression 1 of ORDER BY clause is not in SELECT list,references column，依然无法解决怎么办，MySQL遇到问题，当使用ORDER BY查询时,不能使用SELECT DISTINCT去重查询，mysql在进行多表关联出现报错，在mysql数据库中，遇到报错：Exp
ORDER BY clause is not in SELECT list
michael_linux的博客，一个小小小学生。滴水穿石，步步为营，只为那刹那芳华。
11-18 4122
Error querying database. Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘xxx-数据库.T1.sort’ which is not in SELECT list; this is incompatible with DISTINCT
mysql异常java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list
love_live2的博客
03-22 838
网上查了一下这个是因为数据库开启了only_full_group_by规则校验，执行命令关闭校验就恢复了。最近运维同学升级了数据库后，我们的程序很多接口都报错了一查看是数据库脚本执行报错。执行命令如果不生效的话可能需要重启mysql数据库或者重启服务试试。
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQL
王永存
02-21 1010
问题：[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 ...
Caused by: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, reference
weixin_43232423的博客
01-12 3855
在公司出现以下Bug问题 所以开始研究为什么会出这个问题 找到网上说先执行这个命令 打开mysql客户端,输入 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 再执行 set @@global.sql
mysql：[Err] 1055 - Expression #1 of ORDER BY clause
HY0101的博客
04-02 858
出现问题： [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_f
MySQL操作报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colu
蛤？
03-25 1826
Mysql数据库操作报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat。这个问题主要是由于sql_mode引起，所以先查看sql_mode 然后修改即可，主要是去除only_full_group_by。说明：此方法可以解决大部分mysql8出现的上述报错，配置之后若不生效或启动错误需删除以上配置并需求新的解决方案。
SQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
03-15
具体来说，"Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated"这个错误是指在使用GROUP BY子句进行分组查询时，ORDER BY子句中的表达式不在GROUP BY子句中，并且没有进行...
【异常】记一次因sql_mode错误，导致SyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause报错
本本本添哥
11-27 1010
这个错误信息表示你正在尝试在一个聚合函数（如COUNT、SUM或AVG）和一个非聚合函数（即没有在GROUP BY子句中的函数）之间进行选择操作。在某些情况下，MySQL服务器可能不允许你在GROUP BY语句中使用未在SELECT列表中出现的字段。在MySQL的SQL模式（sql_mode）中，有一个严格模式（ONLY_FULL_GROUP_BY）。如果SELECT列表中的表达式与GROUP BY子句中的列不完全匹配，MySQL会报错并拒绝执行查询。因此，除非你确定知道你在做什么，否则不建议这样做。
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
03-24 5817
SQL 语句报错
MYSQL报错 ：Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
sahbnuymiy的博客
01-26 823
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
MYSQL---Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
JacksonKing的专栏
01-19 1115
--数据库中插入数据或执行sql语句时一直报下面这个错误： 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 c...
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'inform
adreamerisme的博客
08-31 618
mysql在执行insert命令时报错：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 GR...
MySQL Expression 1 of ORDER BY clause is not in SELECT list,references column
04-12 2175
3、MySQL Server 默认开启了 sql_mode=only_full_group_by 模式，此模式要求 group by 字段必须出现在查询项中（select），否则就会报出该错误。mysql5.7版本中，如果DISTINCT和order by一起使用将会报3065错误，sql语句无法执行。在sql语句中使用DISTINCT时不使用order by进行排序，获取结果集后通过php进行数据的排序，同时也提高了mysql的性能。同时group by，limit和其中的一起搭配使用也会导致错误。
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘
Ethe的博客
08-24 188
【代码】Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘
Expression #1 of ORDER BY clause is not in GROUP BY 解决思路
wlh_150568的博客
07-04 507
错误原因： ​ sql _mode中only _full _group _by不兼容的问题 解决思路： ​由于是only _full _group _by不兼容，直接删除即可 show variables like "sql_mode"; set sql_mode=''; set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES...
Mysql问题：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
afei8080的专栏
03-09 1687
MySql only_full_group_by规则
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值