1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains

最新推荐文章于 2025-03-06 21:09:40 发布
最新推荐文章于 2025-03-06 21:09:40 发布
阅读量433 收藏
点赞数
文章标签： 数据库 sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/qq_34815528/article/details/127461632
版权 
select @@global.sql_mode

如果有：ONLY_FULL_GROUP_BY，执行以下语句

set @@global.sql_mode 
='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated 【已解决】
JavaPub
08-30 935
然后重新运行语句，就可以正常查询了。在MySQL下输入如下语句。
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
码农研究僧的博客
04-24 2818
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
sql运行报错：[42000][1055] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggrega
星空_灯塔的博客
07-04 1212
如果重启Mysql服务发现ONLY_FULL_GROUP_BY还是存在的，需要修改配置文件，在window系统中是 my.ini，删除ONLY_FULL_GROUP_BY，重启mysql服务即可。2、直接判断当前会话ONLY_FULL_GROUP_BY是否已设置，可以使用FIND_IN_SET函数（如果MySQL版本支持）或者LOCATE函数，或者直接用LIKE操作符来搜索这个模式。返回结果：是一个由逗号分隔的字符串，列出了所有启用的SQL模式，根据结果查看是否存在 only_full_group_by。
mysql5.7 报错1055:Expression #1 of SELECT list is not in GROUP BY clause and contains non
优快云_ljm的博客
11-07 4086
（参考：https://blog.youkuaiyun.com/qq_24038207/article/details/79358644）经尝试未成功！！！ 在上面修改的基础上，本人成功的解决方法， cd /etc/mysql/mysql.conf.d/     （有的mysql配置文件是 /etc/my.cnf ，而我的Ubuntu16.04 + mysql 5.7.24 下 mysql配置文件是这里...
MySQL 报错: “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column“
总结复盘，才能不迷失自己！
03-06 516
1.问题描述MySQL 中出现 “1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column” 错误？
mysql报错：ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nona
Lucky boy的博客
12-23 1450
执行sql分组 mysql报错：ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nona
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
m0_47734729的博客
08-04 1452
王佳俊 ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated …问题报错解决办法！ 执行sql语句报错： ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘test.fruits.f_id’
MySQL 报错[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregat
qq_59241934的博客
04-28 4596
报错信息： 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...
MySql遇到的问题--group by报错“1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains..”
Dbao_miao的博客
03-20 1858
学习group by遇到的问题表，id为主键 表，id为主键 ±—±---------±----------±--------------------±-----------+ | id | LastName | FirstName | Address | City | ±—±---------±----------±--------------------±-----------+ | 1 | Adams | John | Oxford Street
解决MySQL报出1055-Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated类型的错误
weixin_45775973的博客
07-29 4200
在Mysql（版本为8.0.25）中进行分组查询的时候，频繁报出如下的错误：
mysql报错解决： 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
危险、的博客
01-25 3978
报错如下： 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及以上功
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column报错
每天进步一点点...
11-17 1930
在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 ‘xin
qq_37361514的博客
08-18 283
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xinwu_carnation.pm.moplan_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 执行S
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tab
徊忆羽菲
01-06 2555
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...
[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated colum...
weixin_35753291的博客
01-05 495
[Err] 1055 - Expression #1055 异常是一种 MySQL 数据库错误。这通常表明在执行查询时发生了一个错误，并且查询无法完成。这可能是由于查询语法错误、数据库对象名称错误或其他因素导致的。为了解决这个问题，您可以尝试检查查询语法、确保您使用的数据库对象名称是正确的，并且确保您有足够的权限来执行此查询。 ...
报错，＞ 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
泗水六年的博客
10-29 2329
错误1： mysql： select * ,count(*)as count from app_cash_trans_log group by app_cash_trans_log.tran_code having count(*)>=(select pla_config.cfg_value from pla_config where pla_config.cfg_name='tranMaxContinuity') order by app_cash_trans_log.id desc limit 5
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains n
最新发布
04-03
错误 `1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column` 主要是由于 SQL 查询违反了 MySQL 的严格模式（strict mode）规则引起的。 当查询包含 `GROUP BY` 子句时，MySQL 要求所有出现在 `SELECT` 列表中的字段要么属于聚合函数的结果（如 `SUM()`、`COUNT()` 等），要么明确地列出在 `GROUP BY` 中。这是因为，在分组后的结果集中，未参与聚合计算的列可能对应着多个值，数据库无法确定应该返回哪一个具体的值。 ### 解决方案 1. **检查并修正SQL语句** 如果你希望每个非聚合列只代表每组的一个唯一值，则需要将这些列添加到 `GROUP BY` 子句中。例如： ```sql SELECT a, b, SUM(c) FROM table_name GROUP BY a, b; ``` 2. **更改配置文件设置** (不推荐) 修改 MySQL 配置以关闭仅允许安全分组的功能 (`ONLY_FULL_GROUP_BY`) 。但这不是最佳实践，因为它可能会导致不可预见的数据一致性问题。 3. **使用ANY_VALUE() 函数**(适用于特定场景)** 在某些情况下，如果确实不需要关注某一列的具体取值而只是想让它作为辅助信息显示出来的话，可以采用 `ANY_VALUE()` 来指定该列： ```sql SELECT ANY_VALUE(a), b, SUM(c) FROM table_name GROUP BY b; ``` 这样做会告诉数据库引擎随意选取某个记录中的a值即可。 以上就是针对此错误的一些处理办法，选择合适的方式取决于实际业务需求以及数据结构特点。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值