jdbc4.MySQLSyntaxErrorException:Expression #2 of SELECT list is not in GROUP BY clause and contains

最新推荐文章于 2025-09-25 16:08:49 发布

原创最新推荐文章于 2025-09-25 16:08:49 发布 · 2.6k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

mysql 专栏收录该内容

18 篇文章

订阅专栏

本文介绍了解决Eclipse JavaWeb项目中遇到的ONLY_FULL_GROUP_BY限制导致的问题。通过修改全局SQL_MODE，去除ONLY_FULL_GROUP_BY，确保查询正常进行。

今天在用eclipse做java web项目时，遇到这样一个坑

用sql查询：

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_GROUP_BY，重新设置值。

set @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

spfLinux

关注关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

【异常】记一次因sql_mode错误，导致SyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause报错

奶爸的编程之路，也就一周冷个三天，欢迎关注我的微信公众号：本本本添哥

11-27

1183

这个错误信息表示你正在尝试在一个聚合函数（如COUNT、SUM或AVG）和一个非聚合函数（即没有在GROUP BY子句中的函数）之间进行选择操作。在某些情况下，MySQL服务器可能不允许你在GROUP BY语句中使用未在SELECT列表中出现的字段。在MySQL的SQL模式（sql_mode）中，有一个严格模式（ONLY_FULL_GROUP_BY）。如果SELECT列表中的表达式与GROUP BY子句中的列不完全匹配，MySQL会报错并拒绝执行查询。因此，除非你确定知道你在做什么，否则不建议这样做。

出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法

码农研究僧的博客

04-24

3091

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

参与评论您还未登录，请先登录后发表或查看评论

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

nemo的博客

07-29

696

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression 今天在使用MP开发时报错missing expression 使用MP也没有写SQL，检查自动生成的SQL中发现NUMBER类型字段名也为number所以报错，在数据库中将字段名改为num 问题解决 ...

报错：Expression #2 of SELECT list is not in GROUP BY（only_full_group_by 模式冲突）

最新发布

2301_81920327的博客

09-25

757

让所有非聚合字段都出现在 GROUP BY 中，但考虑到项目历史代码太多，且团队希望保持兼容性，在旧版本 MySQL 中这能正常运行，但在 MySQL 8.0+ 中会直接报错，因为。，我不仅解决了当前问题，还为后续调优（如字符集、连接数、日志等）打下了基础。此时再运行你的 Java 项目，SQL 查询恢复正常，不再报错。，它使用的是编译时的默认配置。在这些路径中，就会被加载。中，也不是聚合函数。

MySQL SyntaxErrorException SELECT list is not in GROUP BY 报错解决

C_V_Better的博客

03-04

859

错误是由于 MySQL 的模式引起的。通过修改 SQL 查询、修改 MySQL 配置或使用聚合函数，可以解决这个问题。在实际开发中，建议根据具体需求选择合适的解决方法。

[mysql] Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lo...

a84480766的博客

04-26

194

执行SQL: SELECT login_name,login_ip,sex FROM tank_admin GROUP BY login_name ; 时抛出异常。 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'loser.tank_admin....

MYSQL---之严格模式详解

weixin_45932995的博客

12-07

1118

严格模式参数详解： sql_mode ONLY_FULL_GROUP_BY 对于GROUP BY聚合操作，如果在SELECT中的列，没有在GROUP BY中出现，那么这个SQL是不合法的，因为列不在GROUP BY从句中。简而言之，就是SELECT后面接的列必须被GROUP BY后面接的列所包含。如： select a,b from table group by a,b,c; (正确) se...

mysql出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre错误

qq_44137730的博客

12-16

521

使用Navicat按F6打开命令列界面输入：select @@global.sql_mode; 将其中的ONLY_FULL_GROUP_BY去掉输入： set @@global.sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION’;

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #4 of SELECT list i

知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】

11-04

1073

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXXXX.l.rate' which is not functional...

03-12

$$ \text{Expression \#1 of SELECT list is not in GROUP BY clause...} $$ 说明SELECT中的`sa.app_name`既不在GROUP BY子句中，也不是聚合函数（如MAX、MIN等）包裹的字段，违反了MySQL的严格模式规则。 --- ###...

解决MySQL 5.7.9版本sql_mode=only_full_group_by问题

12-16

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘col_user_6.a.START_TIME’ which is not functionally dependent on columns in GROUP BY clause; this is ...

SELECT list is not in GROUP BY clause and contains nonaggregated column---Linux工作笔记049

添柴程序猿的专栏

07-10

497

如果你一个系统,以前用的是mysql的版本是:5.6.22 然后,后来,你再安装mysql的时候版本变成5.7.32 等等了,其实就是说,以前你用的 mysql版本是5.6.xx,后来用5.7.xx了,这样在你程序没变的时候,就会报这个错误: \### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list ...

MySQL Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column异常处理

Yeats_Liao的博客

04-23

3460

MySQL Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column异常处理

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column

weixin_45626288的博客

03-29

3352

1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wsq.m.chat_room_id' 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 nonaggre的问题

CharlesYooSky的博客

04-10

329

mysql产生的异常： 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 incom...

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated

baidu_41931697的博客

06-27

592

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated

解决Mysql：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated