MySql错误；ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nona

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

意思是MySql在低版本（5.7.x以下）中允许select后面的非聚合列不出现在group by中。以下sql在低版本中是可以运行的，但是在5.7及以上版本会报错。也就是查询的字段select,要出现在group by后面。

peter.pang
关注
Mysql使用group by分组,现错误ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and
街角有人祝福,巷口有人哭~
06-09 1216
报错信息: 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
mysql 遇到此问题解决办法：Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggre
永远年轻
05-25 4524
问题出现原因： 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,
ERROR 1055 (42000): Expression #1 of SELECT list is not in
lxw1844912514的博客
02-04 1137
报错:ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains no...
MySQL 报错: “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column“
最新发布
总结复盘，才能不迷失自己！
03-06 702
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 1454
执行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
zhl_BeginLife的博客
10-15 478
有一天我们的测试反馈了一个问题如下： ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dev.id' which is not functionally dependent on columns ...
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报错 ：Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
sahbnuymiy的博客
01-26 849
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column
MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法
m0_52789121的博客
06-07 1368
今天使用mysql简单的一句分组查询语句（GROUP BY）报错了。 查了问题原因和解决方法，成功解决。原因：使用GROUP BY 语句违背了sql_mode=only_full_group_by。因为mysql版本5.7之后默认的模式是ONLY_FULL_GROUP_BY。官网文档的原话： 说人话，大概意思就是说（使用google翻译）：1、先使用SQL查询sql_mode 2、重新设置sql_mode，删除ONLY_FULL_GROUP_BY 3、退出重进 再次执行查询语句，...
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘c.countFan
weixin_43802097的博客
05-12 1340
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
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause（亲测可用2020 mac）
hello_world
12-15 397
问题：mac 下不能使用 group by 分组查询，如下图 解决方法：修改变量 sql_mode 的值 具体步骤： 1、mac 下 mysql 的配置文件是 /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist 文件，管理员命令打开文件，输入密码 sudo vim /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist 2、设置 sql_mode=STRICT_TRANS_
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate...
我是jjking`
09-09 674
执行sql语句报错： ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.fruits.f_id' which is not functionally dependent on columns in GROUP BY c...
Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
李利科
02-01 3630
执行以下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 nonaggre的问题
热门推荐
小胖_@的博客
10-29 3万+
mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题 报错如下 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘csdn.liulancsdnbl...
mysql使用group by分组时出现错误ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and
antrychme的博客
08-22 2万+
使用mysql，group by分组时出现错误： 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 c...
mysql ONLY_FULL_GROUP_BY 报错
大虾的世界
08-08 896
mysql ONLY_FULL_GROUP_BY 报错 报错信息： [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 functiona...
1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
08-19
- *1* [MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona...](https://download.youkuaiyun.com/download/weixin_38742656/13685329)[target="_blank" data-report...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值