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

最新推荐文章于 2024-08-09 12:44:01 发布

转载最新推荐文章于 2024-08-09 12:44:01 发布 · 221 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://blog.youkuaiyun.com/qq_34707744/article/details/78031413

数据库操作专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍了如何解决MySQL5.7.5及更高版本中因ONLY_FULL_GROUP_BY SQL模式导致的查询错误。通过调整MySQL配置文件中的sql_mode设置，可以避免在使用GROUP BY时遇到的功能依赖检测问题。

问题出现的原因：

MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用在GROUP BY子句中既未命名的非集合列，也不在功能上依赖于它们。（5.7.5之前，MySQL没有检测到功能依赖关系，默认情况下不启用ONLY_FULL_GROUP_BY。有关5.7.5之前的行为的说明，请参见“MySQL 5.6参考手册”。

1.打开mysql配置文件

sudo vim /etc/mysql/conf.d/mysql.cnf

在底部粘贴：

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

2.保存后重启mysql服务

sudo service mysql restart

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

s_daqing

关注关注

0
点赞
踩
0

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

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

DN金猿的博客

06-28

1355

经过查询资料发现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

3106

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：SELECT list is not in GROUP BY clause 报错解决方案

换条路吧，编程没意思的~

06-20

6393

MySQL 报错：SELECT list is not in GROUP BY clause and contains nonaggregated column 解决方案

Expression #1 of SELECT list is not in GROUP BY clause and xxxx sql_mode=only_full_group_by

GalenGao

07-17

397

异常描述公司的老项目代码拿到本地启动的时候，mysql 报了以下错误： Caused by: org.hibernate.exception.SQLGrammarException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'framework_mj.agile_board_star.id' which is not functionally dependent on

mysql Expression #1 of SELECT list is not in GROUP BY

YZBPXX

05-18

207

出现这个错误可以用 mysql>select @@sql_mode; 查看@@sql_mode 是否包括了ONLY_FULL_GROUP_BY这个模式只在当时有效 SET sql_mode=(SELECT REPLACE(@@sql_mode,‘ONLY_FULL_GROUP_BY’,’’)); 永久有效需要更改配置文件, linux 在/etc/my.cnf , windows在my.ini 设置(没有ONLY_FULL_GROUP_BY 后的select @@sql_mode;.

解决 idea报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre

weixin_43864927的博客

01-09

1023

idea报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 写了一个查询语句执行的时候，idea日志报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 在Navicat中执行也会报这个...

解决[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated

RuigeO的博客

01-17

503

1.切到etc目录下：cd /etc 2.查看内容：cat my.cnf 或 cat my.cnf more 可以看到sql_mode的值，这个值是我改过之后的值，没改之前是ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE或者没有sql_mdoe这个变量没有则需要添加即可。 3.修改文件：vi my....

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

m0_48296376的博客

03-24

2298

错误 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

navicat15执行查询出现错误:Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated

ahmcwt的专栏

11-24

860

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,运行就报错,

MySQL 报错[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregat

qq_59241934的博客

04-28

4658

报错信息： Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tp_music.singer.name’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group...

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

Jack魏

09-09

1239

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'music_partner.m.id' which is 1. 把你要分组的字段设置成设成primary key 或者 unique NOT NULL。2.关闭sql_mode=ONLY_FULL_GROUP_BY3.原...

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

BigCandidate的博客

07-03

448

我把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遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题

charlene717的博客

09-25

994

报错信息原因 MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用在GROUP BY子句中既未命名的非集合列，也不在功能上依赖于它们。（5.7.5之前，MySQL没有检测到功能依赖关系，默认情况下不启用ONLY_FULL_GROUP_BY。有关5.7.5之前的行为的说明，请参见“MySQL 5.6参考手册”。）解决方法一、用sql查询 ...

mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre

weixin_42260782的博客

01-20

1321

同一个程序，运行在dev和prod不同环境里，同一个接口竟然一个正常，一个报错500，但是数据库的数据都一样的，搜了很久，终于在一篇文章里面解决了：问题出现的原因： MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用在GROUP BY子句中既未命名的非集合列，也不在功能上依赖于它们。（5.7.5之前，MySQL没有检测到功能依赖关系，默认情况下不启用ONLY_FU

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