mysql 错误代码： 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated c

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

对于GROUP BY聚合操作，如果在SELECT中的列，没有在GROUP BY中出现，那么将认为这个SQL是不合法的，因为列不在GROUP BY从句中。原因个人认为是消除了子查询的排序作用。而且官方也支持这个判断：（添加链接描述）

在这个模式下，我们使用分组查询时，出现在select字段后面的只能是group by后面的分组字段，或使用聚合函数max/min/avg/count 等包裹着的字段。
解决方法：

  1. 可以通过更改查询模式，允许select的列不在group中出现
  2. 使用聚合函数包裹字段
  3. 使用any_value函数包裹字段
  4. GROUP BY中使用PRIMAY KEY 或 UNIQUE NOT NULL字段（时，不受ONLY_FULL_GROUP_BY的约束。）
  5. 修改my.ini文件中 [mysqld] 的sql_mode中ONLY_FULL_GROUP_BY
Karagrade
关注
专栏目录
mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DN金猿的博客
06-28 235
经过查询资料发现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 1443
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使用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
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 子句中或没有使用聚合函数所导致的。本文将详细介绍这一错误的原因，并提供相应的解决方法。
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 先说产生这个
MySQL 报错[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregat
小洪帽i的博客
10-12 6026
报错：使用 group by 导致错误 [Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'myphp.xiaofei.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_gr
mysql查询报[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregat
VIP_1205169154的博客
11-03 1106
一、错误信息如下： [Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'selfsturoom.a.studycontent' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_gro
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`子句中...
解决MySQL报出1055-Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated类型的错误
weixin_45775973的博客
07-29 4135
在Mysql（版本为8.0.25）中进行分组查询的时候，频繁报出如下的错误：
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘c.countFan
weixin_43802097的博客
05-12 1273
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
MySql遇到的问题--group by报错“1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains..”
Dbao_miao的博客
03-20 1784
学习group by遇到的问题表，id为主键 表，id为主键 ±—±---------±----------±--------------------±-----------+ | id | LastName | FirstName | Address | City | ±—±---------±----------±--------------------±-----------+ | 1 | Adams | John | Oxford Street
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...
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配置文件是这里...
[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated colum...
weixin_35753291的博客
01-05 455
[Err] 1055 - Expression #1055 异常是一种 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及以上功
mysql5.7报错1055, “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
Mr_chenweida的博客
07-10 513
cd /etc/mysql/mysql.conf.d/（没有找到就去 /etc/my.cnf ） sudo vim mysqld.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" 重启mysql：/etc/init.d/mysql restart (Debia.
Mysql 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate 报错解决方案
qq_36141369的博客
12-24 865
报错信息：1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xxxx.xxxx.xxx’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Time: 0.000000s 在
Mysql：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
08-25
引用:1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'senior_two.score.student_id' which is not functionally dependent on columns in GROUP BY clause;...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值