2021-01-11

最新推荐文章于 2024-09-27 11:26:15 发布

超哥的博客

最新推荐文章于 2024-09-27 11:26:15 发布

阅读量139

点赞数

文章标签： mysql

本文链接：https://blog.youkuaiyun.com/qq_38756314/article/details/112482526

版权

博客围绕MySQL出现的SQLSTATE[42000]错误展开，指出SELECT列表的表达式不在GROUP BY中，详细阐述了该错误产生的原因，并给出了解决办法，帮助开发者解决相关问题。

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

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY

1.原因

MySQL 5.7.5和up实现了对功能依赖的检测。如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测到功能依赖项，only_full_group_by在默认情况下是不启用的。关于前5.7.5行为的描述，请参阅MySQL 5.6参考手册。)

2.解决

打开mysql配置文件，在[mysqld]下添加如下一行：sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES，保存重启就好

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

超哥的博客

关注关注

0
点赞
踩
0

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

MySQL报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column whic

weixin_63716356的博客

07-24

2062

MySQL报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column whic字面翻译： SELECT 列表的表达式 #1 不在 GROUP BY 子句中，并且包含非聚合列“grades.order_id” 它在功能上不依赖于 GROUP BY 子句中的列；这与 sql_mode=only_full_group_by 不兼容使用GROUP BY 语句违背了 sql_mode=only_

2021-01-11-raspios-buster-i386.iso 百度网盘

02-12

树莓派系统镜像 2021-01-11-raspios-buster-i386.iso

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

数据库实践丨MySQL多表join分析（转载）

forest_tree的博客

09-03

289

Join并行 Join并行多表join介绍多表Join的方式不使用Join buffer 使用Join buffer 3. Join执行流程（老执行器）多表join介绍 JOIN子句用于根据两个或多个表之间的相关列来组合它们。例如： Orders： OrderID CustomerID OrderDate 10308 2 1996-09-18 10309 37 1996-09-19 10310 77 1996-09-20 Customers： CustomerID Customer

解决mysql5.7Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '

果冻小玩纸的博客

06-20

407

mysql5.7报错：Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.t_long.user_name' which is not functionally dependent on columns in GROUP BY clause; this ...

MySql5.7Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre异常

qq_21161439的博客

01-02

246

问题出现情况按照客户要求把我们平时使用的云数据库迁移到在客服服务器上装的Mysql，其他一切良好，运行某个包含Group by 语句的时候出现以下错误 Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause ...

mysql5.7中报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre

BigCandidate的博客

07-03

406

我把mysql5.1升级到5.7后，打开项目，出现各种查询异常，看了日志就是mysql的问题。用mysql-Front客户端远程连接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..

mysql的sql_mode设置

m0_38102561的博客

09-05

726

mysql的sql_mode设置 1、查询sql_mode select @@GLOBAL.sql_mode 或 select @@SESSION.sql_mode 2、设置sql_mode 通过命令设置 SET GLOBAL sql_mode = 'modes...'; 或 SET SESSION sql_mode = 'modes...'; 在配置文件中设置在/etc/my.cn...

ffmpeg-4.3.1-2021-01-01-essentials_build.rar

04-12

在“ffmpeg-4.3.1-2021-01-01-essentials_build.rar”这个压缩包中，提供的是一套预编译的 FFmpeg 基础构建，专为简化安装和使用过程设计。 FFmpeg 的主要特点包括： 1. **多格式支持**：FFmpeg 支持众多的音频和...

APToolV7200(2021-02-01)

12-13

APTool-UMPTooV7200 是一款专门用于量产chipsbank主控U盘的工具。这款工具的主要功能是对U盘进行量产操作，也就是通过制作U盘固件，将U盘的物理存储芯片的空间划分为分区，赋予U盘可读写和存储的功能。...

gtk2-runtime-2.24.33-2021-01-30-ts-win64.exe

07-14

gtk2-runtime-2.24.33-2021-01-30-ts-win64.exe

tampermonkey-backup-chrome-2021-11-27T13-18-01-624Z.zip

11-27

下载后通过Tampermonkey直接导入即可使用。

MySQL5.7报错问题 SELECT list is not in GROUP BY clause and contains nonaggregated column

龚清林的博客

12-10

3965

MySQL5.7.5后默认启用了ONLY_FULL_GROUP_BY，这可能导致一些sql语句失效问题解决方法1：如果使用Navicat软件，执行查询语句： 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_AUTO_CREATE_USER,

报错：In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column

qq_36216193的博客

10-16

4449

sql语句报错内容： Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column '...

报错In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column ‘

最新发布

Devil_MayCare的专栏

09-27

657

版本为5.7以上的版本，默认开启了 ONLY_FULL_GROUP_BY SQL模式，在此模式下，对于group by操作,如果在select语句中的查询列没有在group by中出现，那么这个SQL就是非法的，因为列不在group by语句中，所以设置了sql_mode=only_full_group_by的数据库，在使用group by时就会报错。然后关闭数据库重新打开，在执行sql即可。

In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column ‘ki

weixin_43863128的博客

04-07

303

In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column ‘kinglink_db_devII.f.id’; this is incompatible with sql_mode=only_full_group_by 反例： SELECT f.*,COUNT(p.id) FROM fms_firmware f LEFT JOIN fms_firmware_package p

MySQL报错： Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

陈一一同学的博客

06-21

2802

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### ....

myql报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

IT大神帅杰的博客

05-24

426

myql报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

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

weixin_44586943的博客

03-08

195

话不多说，直接解决。此方法是永久解决，如需临时解决，直接看文章结尾即可。第一步，使用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_ENGINE_SUBSTITUTION 第二步，将前面 ‘ONLY_FULL_GROUP_BY’ 去除，留下后一段 STRICT_TRANS_TA

MYSQL||报错：In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated