数据库报错：SELECT list is not in GROUP BY clause

最新推荐文章于 2023-12-15 13:52:58 发布
最新推荐文章于 2023-12-15 13:52:58 发布
阅读量248 收藏
点赞数
分类专栏： mysql 文章标签： 数据库 list mysql
原文链接：https://www.codeleading.com/article/35982582986/
版权

mysql5.7使用group by出现错误：

[Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.score.c_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

phpstudy解决方法：在phpstudy的mysql.ini文件中添加

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
lmp5023
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
12-15
原因: 　　 MySQL 5.7.5和up实现了对功能依赖的检测。如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测到功能依赖项，only_full_group_by在默认情况下是不启用的。关于前5.7.5行为的描述，请参阅MySQL 5.6参考手册。) 　　执行以下个命令，可以查看 sql_mode 的内容：　　 mysql> SHOW SESSION VARIABLES; mysql> SHOW GL
MySQL使用中遇到的问题记录
12-15
这儿记录一些在使用MySQL的过程中遇到的问题以及相应的解决办法。 sql_mode=only_full_group_by引起group by查询报错 问题 MySQL执行 GROUP BY 查询报错： #1 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by 解决办法 # 设置正确的 sql_mode 即可解决 # 登陆MySQL sudo mysql
MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
12-14
[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 functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 在navicat中使用mysql加索引或者删除索引时报了这个错。 两种解决方
mysql遇到Expression.docx
03-05
mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
laravel5.8（二十五）解决使用groupby报错SELECT list is not in GROUP BY clause and contains nonaggregated column
camellia的博客
06-16 1068
在laravel中数据库查询使用groupby报错： SQLSTATE[ 42000 ]: Syntax error or access violation: 1055 Expression # 1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sns.sns_users.md_img' which is not functionally dependent on columns i
【MYSQL】SELECT list is not in GROUP BY clause: mysql数据库异常解决方案
dkz97的博客
06-29 6321
SELECT list is not in GROUP BY clause: mysql数据库异常解决方案前言问题及需求解决方案合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 前言 你好！ 这是你第一次使用 Markdown编辑器 所展示的
报错 SELECT list is not in GROUP BY clause
湖边的小屋圣迹
08-17 1万+
[Err] 1055 - Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxx' which is not functionally dependent on columns in GROUP BY clause; this is incompatible wit...
SELECT list is not in GROUP BY clause...
一起学习前端知识，一起成为前端开发工程师！
04-21 215
线上服务器数据库查询使用了 GROUP BY 居然报出了 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'csc_risk.a.DefaultDate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=onl
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...原因及解决方案
江海寄余生的博客
03-30 1万+
最近公司新建了一个项目，在项目中需要用到group by进行聚合计算，在计算的同时也要查出一些其他字段来返回给前端。于是就有了这个错误的出现。 先简单复现我所写的sql，其实sql非常简单。 select channel_name as channelName, brand_name as brandName, sum(actual_value) as actualValue, sum(actual_value_ty) a
SELECT list is not in GROUP BY clause and contains nonaggregated column解决和总结
ITxiaofeixiang的博客
04-12 4万+
问题描述 查询语句 SELECT name,sum(class_id) from res GROUP BY class_id 结果 SELECT list is not in GROUP BY clause and contains nonaggregated column ‘dt.res.name’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=o
Mysql升级到5.7后遇到的group by查询问题解决
12-16
发现问题 最近在将mysql升级到mysql 5.7后，进行一些group by...SELECT list is not in GROUP BY clause and contains nonaggregated column ‘news.id' which is not functionally dependent on columns in GROUP BY c
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...
Deprecated: Function xxx() is deprecated
我是谁的专栏
11-17 1万+
1,Deprecated: Function ereg_replace() is deprecated 在php5.3.0后的版本，取消了对ereg函数的支持，惹得若干程序需要改动，譬如我安装的zen-card1.3.8，颇不方便。 错误：Deprecated: Function ereg() is deprecated in …… 解决方法一：退回去用php5.2 解决方法二：继续用
mysql常见报错之SELECT list is not in GROUP BY clause
从兄的博客
05-21 1292
开发中使用group by报错，错误信息： 1055:Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 原来是因为mysql5.7及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQL模式(默认情况下)，MySQL将拒绝选择列表 解决方法： 1、查询sql_mode sql：select @@global.sql_mode; 2、去掉ON...
No package XXX available
weixin_44303109的博客
07-06 167
这里写自定义目录标题 yum problem1(Centos7) :No package XXX available Solution: yum install epel-release
sql报错SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_40262372的博客
06-24 9471
高频面经汇总：https://blog.csdn.net/qq_40262372/article/details/116075528 一、问题分析 其中错误的原因是说group by哪一句中的select的字段是不对的。 二、情景还原 dept_emp表： salaries表： 我想去查询每个部门人员薪水，于是写下了这样的sql: select de.dept_no ,s.salary from dept_emp de left join salaries s on..
mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic
最新发布
A乐神的博客
12-15 3858
mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...解决方案
热门推荐
study_in的博客
06-19 7万+
MySQL5.7.5后only_full_group_by成为sql_mode的默认选项之一，这可能导致一些sql语句失效。 比如在使用group by进行分组查询报错 1 查看自己的sql_mode配置: 在sql命令行中输入select @@sql_mode;这时我们能够看到自己的sql_mode配置,其中如果有ONLY_FULL_GROUP_BY,那它就是group by查询报错的罪魁祸...
mysql group by 报错Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated c
wuxiaopengnihao1的博客
09-05 3920
这是MySQL8.0默认开启only_full_group_by模式导致的，该模式限定select后面跟的列，在group by后面必须要有。好了， 以上是本文所有内容，希望对大家有所帮助，也希望大家对。多多支持，你们的支持是我创作的动力！：该方式重启mysql会失效。修改配置文件my.cnf。重启mysql即可。
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column
07-27
回答: 当使用GROUP BY语句进行查询时，SELECT语句中只能包含GROUP BY后面声明的列或者聚合函数。这是因为MySQL的ONLY_FULL_GROUP_BY模式要求SELECT语句中的列必须是明确的，以确保分组求最值的合法性检查。这种模式采用了与Oracle、DB2等数据库的处理方式。因此，如果在GROUP BY语句中使用了聚合函数，就需要将SELECT语句中的列限制在GROUP BY后面声明的列或者聚合函数中。如果SELECT语句中出现了不明确的列，就会报错"SELECT list is not in GROUP BY clause and contains nonaggregated column"。\[1\]\[2\]\[3\] #### 引用[.reference_title] - *1* [mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.](https://blog.csdn.net/weixin_40925480/article/details/127680083)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] - *2* *3* [mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column......](https://blog.csdn.net/weixin_37557729/article/details/123896433)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值