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

最新推荐文章于 2024-07-23 14:48:04 发布

L小菜鸟L

最新推荐文章于 2024-07-23 14:48:04 发布

阅读量2.8k

点赞数 1

分类专栏： bug Mysql 报错文章标签：数据库

本文链接：https://blog.csdn.net/qq_43156369/article/details/105051090

版权

Mysql 同时被 3 个专栏收录

4 篇文章 0 订阅

订阅专栏

bug

2 篇文章 0 订阅

订阅专栏

报错

2 篇文章 0 订阅

订阅专栏

mysql 5.7 以上版本默认开启 ONLY_FULL_GROUP_BY；

在这个模式下，我们使用分组查询时，出现在select字段后面的只能是group by后面的分组字段，或使用聚合函数包裹着的字段，否则即会报错。

查看模式状态：

select @@global.sql_mode;

解决方式就是关掉这个模式，即：

set @@GLOBAL.sql_mode=’’;
set 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年卡可用

立即使用

L小菜鸟L

关注关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录

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

DN金猿的博客

06-28

242

经过查询资料发现group by 聚合操作的时候，进行查询操作的列没有在group by 中出现，那么这个sql就是不合法的。主要原因就是设置的与sql_mode=only_full_group_by不兼容。今天在mysql5.7.x 升级到8.0.x版本的时候项目接口报错。通过查询发现mysql5.7.5及以上的版本都会依赖检测功能,也就是默认会开启only_full_group_by。8.0.x的版本不支持NO_AUTO_CREATE_USER，去掉即可。

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

码农研究僧的博客

04-24

1460

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

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

MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…

12-14

[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_full_group_by 在navicat中使用mysql加索引或者删除索引时报了这个错。两种解决方

mysql 遇到此问题解决办法：Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggre

永远年轻

05-25

4323

问题出现原因： MySQL 5.7.5 及以上功能依赖检测功能，如果启用了 ONLY_FULL_GROUP_BY SQL 模式(默认情况下启用)，MySQL 将拒绝选择列表，Having 条件或 Order by 列表的查询引用在 Group By 字句中即未命名的非集合列，也不在功能上依赖于它们。解决方法一【重启服务就会失效】： // 使用 sql 查询 select @@global.sql_mode // 查询出来的值为 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,

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

最新发布

qq_38254635的博客

07-23

458

Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column '数据库.表.字段' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

[Linux 完美解决]Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column

m0_48296376的博客

03-24

2139

错误 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 一、其他参考文档临时解决方法: Mysql解决SELECT list is not in GROUP BY clause and contains nonaggregated column 问题另一个: mysql遇见Expression #1 of SELECT list is not in GROUP BY clau

Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘medical.m.

weixin_46653239的博客

10-23

976

今天在工作中遇到了一个问题，大佬给了一个特别简单的解决方案首先尝试下这个代码，你会发现他和你遇到的问题是一样的额 with ta as ( select 1 a , 2 b from dual union all select 1 , 3 ) select a ,b from ta group by a ；解决方式： set sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISIO...

Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘constructi

qq_43807797的博客

09-05

301

1、找到my.cnf文件，并编辑 MySQL 的配置文件 my.cnf。一般都在etc/my.cnf或者etc/mysql/my.cnf。输入命令：sql_mode = 新的 sql_mode 值。5、使用 systemctl list-units | grep mysql 命令来查找 MySQL 服务的确切名称。3、在 [mysqld] 部分中添加或更新 sql_mode 配置。输入----> :w!2、在文件中找到 [mysqld] 部分。命令：sudo vi /etc/my.cnf。

mysql高版本中使用group by报错：[Err] 1055 - Expression #6 of SELECT list is not in GROUP BY clause and contai

angboom的博客

02-24

497

问题：mysql高版本中使用group by报错：[Err] 1055 - Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘test_project.b.cid’ which is not functionally dependent on columns in GROUP BY clause;，可以将需要分组的字段在select 中展示出来，不用。

mysql报错SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xxx‘.

Gblfy_Blog

10-14

1085

mysql报错SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xxx‘.

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘c.countFan

weixin_43802097的博客

05-12

1274

mysql中的sql__@@mode问题，导致sql无法运行 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c.countFangWenCiShuByToday' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only

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

qq_36627328的博客

04-16

513

原因出现此问题的原因是 MySQL 5.7.5 之后默认开启了 ONLY_FULL_GROUP_BY sql_mode。对此官方的解释：MySQL 实现了函数依赖性的检测。如果启用了 ONLY_FULL_GROUP_BY SQL模式（默认情况下是这样），MySQL 将拒绝 select list、HAVING condition 或 ORDER BY list 引用的未聚合列，这些列既不在 GROUP BY 子句中命名，也不在功能上依赖于它们。解决方法当然，最好的解决方法当然是修改优化 sql 语

SELECT list is not in GROUP BY clause and contains nonaggregated column

小皮的博客

11-27

288

报错如下： 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 inc...

MYSQL 错误解决 SELECT list is not in GROUP BY clause and contains nonaggregated column

lbuskeep的专栏

11-07

4178

温馨提示：1、如果是 linux 操作系统在/etc/mysql/conf.d/mysql.cnf 下做修改 2、如果是 windows 操作系统在 mysql 目录下修改 mysql.ini 修改操作： 1、进入文件后在 [mysqld] 最后一行加以下代码 sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,...

Mysql解决SELECT list is not in GROUP BY clause and contains nonaggregated column 问题

随笔

01-10

1610

解决办法：三步走，实测有效！！！ 1：--查看数据库sql查询模式 select @@GLOBAL.sql_mode; 2：-- 去除only_full_group_by 模式设置，保留第一步查询出来的其他配置项 set GLOBAL sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVIS...

MySQL中Group By遇到 SELECT list is not in GROUP BY clause and contains nonaggregated ........

xiaoxu9522的博客

07-09

1012

遇见的报错具体是这样的： Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'a .time2' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 大概的意思就是：select 语句中的

sql报错SELECT list is not in GROUP BY clause and contains nonaggregated column

qq_40262372的博客

06-24

9797

高频面经汇总：https://blog.csdn.net/qq_40262372/article/details/116075528 一、问题分析其中错误的原因是说group by哪一句中的select的字段是不对的。二、情景还原 dept_emp表： salaries表：我想去查询每个部门人员薪水，于是写下了这样的sql: select de.dept_no ,s.salary from dept_emp de left join salaries s on..

mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic

A乐神的博客

12-15

7654

mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic

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

07-29

引用\[1\]、\[2\]和\[3\]都是关于MySQL报错的信息，其中提到了"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"的错误。这个错误是由于在使用GROUP BY子句进行分组查询时，SELECT列表中的某些列没有在GROUP BY子句中出现，并且这些列也没有被聚合函数包含，导致不兼容的错误。这个错误通常是由于MySQL的sql_mode设置为only_full_group_by引起的。解决这个错误的方法是要么将SELECT列表中的列添加到GROUP BY子句中，要么将这些列用聚合函数进行处理，以确保查询的正确性。 #### 引用[.reference_title] - *1* *3* [MySQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ...](https://blog.csdn.net/Saintmm/article/details/124491860)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v4^insert_chatgpt"}} ] [.reference_item] - *2* [Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre](https://blog.csdn.net/weixin_44051060/article/details/105602832)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v4^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]