Expression #4 of SELECT list is not in GROUP 。。this is incompatible with sql_mode=only_full_group_by

最新推荐文章于 2024-02-19 09:38:36 发布
最新推荐文章于 2024-02-19 09:38:36 发布
阅读量933 收藏
点赞数 2
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/oliver_wq/article/details/88875783
本文介绍了如何查询 MySQL 数据库的 SQL 模式，并演示了如何移除 ONLY_FULL_GROUP_BY 选项来调整 SQL 模式的具体步骤。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

sql查询自己数据库的sql mode：

select @@global.sql_mode

结果如下ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERONO_ENGINE_SUBSTITUTION

去掉ONLY_FULL_GROUP_BY，重新设置值：

set @@global.sql_mode
=‘STRICT_TRANS_TABLES,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERONO_ENGINE_SUBSTITUTION’

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #4 of SELECT list i
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
11-04 969
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...
dependent on columns in GROUP BY clause； this is incompatible with sql_mode=only_full_group_by
A-MING的博客
10-27 740
order_num VARCHAR(255) NOT NULL COMMENT '商品订单号',quantity INT(255) NOT NULL COMMENT '商品数量'
MYSQL查询报错 Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column，
陌子曦的专栏
05-07 3997
完整报错如下：Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sa.type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with s...
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated...
working_hewei的博客
11-26 2345
记一个MySql的小坑，在Mysql版本为5.7.25时，在使用使用group by 时，会出现Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated...错误,这个错误的原因是 group by后面需要加上，select中的所有字段。不然就会报这个错误。 解决这个错误方法是更改Linu...
MYSQL报错 ：Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
sahbnuymiy的博客
01-26 899
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated ...
qq_59025975的博客
09-19 5979
在Mysql版本为5.7.25时，在使用使用group by 时，会出现Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated...错误,这个错误的原因是 group by后面需要加上，select中的所有字段。不然就会报这个错误。
解决MySQL 5.7.9版本sql_mode=only_full_group_by问题
12-16
this is incompatible with sql_mode=only_full_group_by ``` 这个错误表明，你在SELECT语句中选择了`START_TIME`这一非聚合列，但它既不在GROUP BY子句中，也没有与GROUP BY子句中的任何列有函数依赖关系。在`ONLY...
MySQL错误-this is incompatible with sql_mode=only_full_group_by完美解决方案
weixin_43102784的博客
02-19 2万+
有时候，遇到数据库重复数据，需要将数据进行分组，并取出其中一条来展示，这时就需要用到group by语句。但是，如果mysql是高版本，当执行group by时，select的字段不属于group by的字段的话，sql语句就会报错。
mysql报错this is incompatible with sql_mode=only_full_group_by解决方案
洛阳泰山的博客
07-26 4576
MySQL报错"this is incompatible with sql_mode=only_full_group_by"是因为在执行查询时，使用了GROUP BY语句但未对所有非聚合列进行聚合处理。这个错误是由于MySQL的sql_mode设置为only_full_group_by导致的。 在MySQL中，sql_mode是用于控制SQL语句执行行为的一个参数。当sql_mode被设置为only_full_group_by时，表示在使用GROUP BY语句时要求对非聚合列进行聚合操作，即所有出现在SE
MYSQL:Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DXIANGH的博客
06-10 1817
mysql only_full_group_by问题
#4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'itripdb.store
Xuyuqinga的博客
04-21 298
报错信息 Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘itripdb.store.store’ which is not functionally dependent on columns in GROUP BY clause; this is incompati...
only_full_group_by
weixin_33738555的博客
06-15 307
2019独角兽企业重金招聘Python工程师标准>>> ...
ONLY_FULL_GROUP_BY
weixin_34150503的博客
03-08 110
为什么80%的码农都做不了架构师？>>> ...
mysql group by 报错 ，only_full_group_by 三种解决方案
weixin_30776545的博客
07-04 431
报错信息 Expression#1ofSELECTlistisnotinGROUPBYclauseandcontainsnonaggregatedcolumn'database.table.column'whichisnotfunctionallydependentoncolumnsinGROUPBYclause;thisisincom...
基于【 bug解决】一 || mysql的ONLY_FULL_GROUP_BY导致的sql语句错误
weixin_30888413的博客
09-28 210
一、Mysql错误: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'ynsl_new.u.user_id'; this is incompatible with sql_mode=only_full_group_by 1、原sql语句...
this is incompatible with sql_mode=only_full_group_by
八轮_Baron的博客
07-31 382
2019-07-31 07:10:12.526 ERROR 10163 --- [nio-7031-exec-2] c.u.t.exception.GlobalExceptionHandler : !!! request uri:/analysis/v1/patrolRiverProblemStatistics/getListTown from 10.0.9.116, 10.0.0.96 s...
only_full_group_by导致group报错
java_javabean的博客
04-25 406
only_full_group_by导致group报错问题解决 问题 Mysql5.7；window系统 sql语句：select DISTINCT(tr.id) from td, tr where td.id=tr.id and td.status=1 and td.type=2 and tr.status=0 group by td.id; 执行时报错：this is incompatib...
Sequelize DatabaseError: ER_WRONG_FIELD_WITH_GROUP: Expression #2 of SELECT list is not in GROUP
qq_39085895的博客
10-21 1088
项目部署后报错 SequelizeDatabaseError: ER_WRONG_FIELD_WITH_GROUP: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘mysql.category.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible
MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法
热门推荐
~~~~~~~BUG FLY~~~~~~~~~
05-14 3万+
项目场景： 最近在部署项目之后，运行出现报错： Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘grades.order_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 'world.student.Sno' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
最新发布
07-12
this is incompatible with sql_mode=only_full_group_by`，通常表明当前MySQL服务器启用了 `ONLY_FULL_GROUP_BY` 的 SQL 模式。 ### 错误原因 此错误的核心在于 MySQL 的 `sql_mode` 设置中包含 `ONLY_FULL_GROUP...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值