[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated colum

最新推荐文章于 2024-08-09 12:44:01 发布
最新推荐文章于 2024-08-09 12:44:01 发布
阅读量1.8w 收藏 12
点赞数 3
分类专栏： mysql 文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/li1325169021/article/details/78344083
版权

官方说法

https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html

一、查询mysql 相关mode

1、show variables like '%sql_mode%'命令

2、select version(), @@sql_mode 命令

查询出的数据如下图：

二、通过select version(), @@sql_mode 命令查询，发现 里面 有  ONLY_FULL_GROUP_BY ， 将其删除掉，

再把sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'，复制到/etc/my.cnf文件中，如下图：

三、然后重启mysql

service mysqld stop       停止mysql服务命令

service mysqld start      启动mysql服务命令


小志的博客
关注
专栏目录
Mysql使用group by分组,现错误ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and
街角有人祝福,巷口有人哭~
06-09 1138
报错信息: ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘advanced.dept.deptno’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_grou
[Err] 1055 - Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
hhczy1003的专栏
08-23 1万+
这个错误发生在mysql 5.7.5 和以后上，因为5.7.5默认的sql模式配置是 ONLY_FULL_GROUP_BY，  这个配置启用的是 “严格ANSIsql 规则”，严格ANSI sql 规则要求在group by的时候，没有聚合的列，在group by的时候，必须全部包含在group by 的字段中。 没有聚合的列，指的是没有使用 max, min, count,
Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
李利科
02-01 3510
执行以下sql报错： SELECT name,sex,location FROM tp_music.singer group by sex; 报错信息： 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 i
完美MySQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column的解
最新发布
科技改变人类，技术成就未来
08-09 1122
在使用 MySQL 时，可能会遇到这样的错误提示：“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column”。这通常是由于在 GROUP BY 查询中，SELECT 列表中的某些列没有被包含在 GROUP BY 子句中或没有使用聚合函数所导致的。本文将详细介绍这一错误的原因，并提供相应的解决方法。
mysql5.7 报错1055:Expression #1 of SELECT list is not in GROUP BY clause and contains non
CSDN_ljm的博客
11-07 4029
（参考：https://blog.csdn.net/qq_24038207/article/details/79358644）经尝试未成功！！！ 在上面修改的基础上，本人成功的解决方法， cd /etc/mysql/mysql.conf.d/     （有的mysql配置文件是 /etc/my.cnf ，而我的Ubuntu16.04 + mysql 5.7.24 下 mysql配置文件是这里...
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cre
weixin_43085797的博客
04-14 1万+
sql语句 SELECT * FROM t_company_change_log WHERE company_id='257949626441666560' AND rec_status='N' GROUP BY change_item 这样会在某些版本的数据库中运行出错 原因是 5.7.5之后版本默认启用了only_full_group_by SQL模式，所以MySQL会不识别选择列表...
mysql报错解决： 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
危险、的博客
01-25 3791
报错如下： 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 incompatible with sql_mode=only_full_group_by 问题出现的原因： MySQL 5.7.5及以上功
MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
12-14
在MySQL中，错误提示 "[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column…” 指的是在执行包含`GROUP BY`子句的查询时，你试图对未在`GROUP BY`子句中...
[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated colum...
05-19
这个错误通常发生在MySQL中，因为MySQL对于GROUP BY查询有一些特殊的限制。 当你在SELECT语句中使用了GROUP BY子句时，MySQL要求在SELECT列表中包含...GROUP BY column1, column2 ``` 这样就可以避免这个错误了。
pymysql.err.OperationalError: (1055, "Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
11-16
这个错误是由于在使用GROUP BY聚合操作时，SELECT语句中的某些列没有在GROUP BY语句中出现，导致SQL语句不合法。解决这个问题的方法是将SELECT语句中的所有列都添加到GROUP BY语句中，或者使用聚合函数对这些列进行...
[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘bxj_face_big_data.i.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
02-07
[Err] 1055 - Expression #1055 异常是一种 MySQL 数据库错误。这通常表明在执行查询时发生了一个错误，并且查询无法完成。这可能是由于查询语法错误、数据库对象名称错误或其他因素导致的。为了解决这个问题，您...
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报错 ＞ 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
weixin_44013783的博客
08-05 1万+
数据库查询时报错 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘dkia_quality_db.b.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 先说产生这个
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tab
徊忆羽菲
01-06 2516
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'table1.sale_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible...
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column报错
每天进步一点点...
11-17 1885
在MySQL语法GroupBy时报错 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db1.product.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by,
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘se
m0_61615803的博客
04-11 7186
模式，即在 GROUP BY 语句中的 SELECT 列表中，只能包含分组或聚合函数，不能包含其他列。而你的查询语句中出现了一个列。列加入 GROUP BY 列表中，这样 MySQL 就能知道如何处理这个列了。这个查询将按学生 ID 分组，并计算每个学生的平均分。这样 MySQL 就不会报出上述错误了。，它既没有被分组也没有被聚合，因此 MySQL 报出了这个错误。这个错误是由于 MySQL 的新版本中默认开启了。Navicat Premium 16 版本。
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
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gra
qq_42384506的博客
04-23 1063
报错内容： 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'graduate.score.score_id' which is not functionally dependent on columns in GROUP BY clause; this...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

小志的博客

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值