解决Mysql报错：QL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonagg

于 2024-02-04 15:33:19 发布
阅读量455 收藏 6
点赞数 8
分类专栏： 后端 mysql 文章标签： mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_55195734/article/details/136026912
版权
本文介绍了在MySQL中遇到SQLError，原因在于开启的严格模式（strict_mode=only_full_group_by）不允许非聚合列出现在SELECT列表中，解决方法是修改my.ini文件中的sql_mode设置并重启MySQL服务。
摘要由CSDN通过智能技术生成

报错信息

SQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated > column ‘rong_hua.oeh.exam_paper_id’ which is not functionally dependent on columns in GROUP > BY clause; this is incompatible with sql_mode=only_full_group_by

报错原因是mysql开启了严格模式，关闭方法如下：

  1. 找到安装目录下的my.ini文件，没有的话就新建一个
  2. 找到mysqld项增加如[mysqld]下的代码
[mysqld]
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'
  1. 重启mysql即可解决报错
BiuBiu__A
关注
专栏目录
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
码农研究僧的博客
04-24 1655
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
navicat15执行查询出现错误:Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated
ahmcwt的专栏
11-24 784
SELECT c.cust_id,c.cust_name,o.order_num,o.order_date,o.cust_id,count(*) from customers c LEFT JOIN orders o on c.cust_id=o.cust_id GROUP BY c.cust_id; 本机:windows10,navicat15,mysql8.0.22 在执行上述语句查询时,因为加了另一个表的字段:o.order_num,o.order_date,o.cust_id,运行就报错,
QlExpress表达式介绍（一）
u013637451的博客
07-01 7999
QLExpress 规则引擎介绍 一个轻量级的类java语法规则引擎，作为一个嵌入式规则引擎在业务系统中使用。让业务规则定义简便而不失灵活。让业务人员就可以定义业务规则。支持标准的JAVA语法，还可以支持自定义操作符号、操作符号重载、函数定义、宏定义、数据延迟加载等 QLExpress之helloworld public static void main(String[] args) t...
mysql的sql_mode设置
m0_38102561的博客
09-05 669
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...
MySQL报错： Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
陈一一同学的博客
06-21 2746
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 clause and contains nonaggregated column 'userinfo.
热门推荐
fansili的博客
11-29 8万+
安装了mysql5.7，用group by 查询时抛出如下异常：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 GR
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
lxw1844912514的博客
09-18 4万+
报错:ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'work_ad.api_community_pic.id' which is not functionally dependent on columns in GROUP B...
解决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 ...
CentOS7伪分布式下 hive安装过程中遇到的问题及解决办法
BIT_SKY的博客
10-24 8239
hive 安装容易出现的错误及其解决办法
Thinking in Enterprise Java
09-28 4108
Thinking in EnterpriseJava by Bruce Eckel et. Al.Revision 1.1, 5-06-2003Please note this document isunder development and incomplete. Updates to this document can be found at http://
关于mysql #1 of SELECT list is not in GROUP BY clause and contains 的问题
sinat_37883343的博客
09-17 831
   今天帮老师修改数据库的一些数据，发现同一条语句在服务器上的数据库中可以执行，但是在我自己电脑的数据库就不可以。错误提示为： #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '******' which is not functionally dependent on columns i...
mysql：报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonag
欢迎来到 ABin-阿斌的博客：写一生代码，创一世佳话，筑一览芳华。
05-24 1157
声明： 原文作者【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 nonag...
Jitwxs
02-25 4801
一、问题描述 运行 sql 后报错： Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘day_offset’ which is not functionally dependent on columns in GROUP BY clause; this is in...
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column...
foryai的博客
03-03 257
报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘dev_xmjt.m.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 报错以及解决办法： mysql 查询语句中select
mysql报错 “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated“的解决办法
papaya的博客
07-01 356
完整报错内容：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'a.logid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by如下图所示 提示得也很清楚 使用 GROUP BY 语句
MySQL报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column whic
小草莓的博客
11-21 2万+
查看官方文档，发现从 MySQL 5.7.5 开始，默认 SQL 模式包括 ONLY_FULL_GROUP_BY。（在 5.7.5 之前，MySQL 不检测函数依赖，并且默认不启用 ONLY_FULL_GROUP_BY）这可能会导致一些sql语句失效。使用GROUP BY 语句违背了 sql_mode=only_full_group_by。可以看到我们的 sql_mode 中含有 ONLY_FULL_GROUP_BY，因此只要将它去掉即可。函数将需要查询的结果包裹，这样就不会报错（不清楚原因）
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
wan_zaiyunduan的博客
09-21 453
1.错误 如果所安装的mysql为 5.7.5 版本及以上版本，如果执行group by时，select的字段不属于group by的字段的话，sql语句就会报错 2.原因 1）mysql 5.7.5版本以上默认的sql配置是:sql_mode=“ONLY_FULL_GROUP_BY” 2）由于开启了ONLY_FULL_GROUP_BY的设置，如果select 的字段不在 group by 中， 并且select 的字段未使用聚合函数（SUM,AVG,MAX,MIN等）的话，那么这条sql查询是被m
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
MySQL解决报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column. macbook怎么解决这个报错
最新发布
12-27
在MySQL中，当使用GROUP BY子句对结果进行分组时，SELECT列表中的列必须要么是分组的列，要么是聚合函数的结果。否则，会出现报错"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"。解决这个报错的方法有两种： 1. 使用聚合函数对非分组列进行聚合操作。 2. 修改MySQL的sql_mode参数，将其设置为非严格模式。 下面是两种解决方法的示例： 方法一：使用聚合函数对非分组列进行聚合操作 ```sql SELECT custname, MAX(salary) FROM your_table GROUP BY custname; ``` 方法二：修改MySQL的sql_mode参数 ```sql SET sql_mode = 'ONLY_FULL_GROUP_BY,NO_AUTO_CREATE_USER'; ``` 请注意，修改sql_mode参数可能会影响其他查询的行为，因此在修改之前请确保了解其影响。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值