mysql 使用group by 查询报以下错误1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

最新推荐文章于 2024-08-09 12:44:01 发布

原创最新推荐文章于 2024-08-09 12:44:01 发布 · 605 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

数据库

当前文章被收录于：

数据库

4 篇文章 0 人学习

订阅专栏查看详情

当前文章被以下社区和专栏收录：

本文介绍了解决MySQL因版本问题导致无法正常启动的方法。通过在配置文件中添加特定参数，可以确保MySQL服务正确运行。

根据网上一些说法是版本原因

直接在mysql配置文件中添加以下代码即可，配置文件中如果存在 [mysqld] 则可以省略掉，直接滚动到最后添加

[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

运行命令

 service mysql restart

标签

#mysql group by

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

con_knife

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

MySQL报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column whic

weixin_63716356的博客

07-24

2297

MySQL报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column whic字面翻译： SELECT 列表的表达式 #1 不在 GROUP BY 子句中，并且包含非聚合列“grades.order_id” 它在功能上不依赖于 GROUP BY 子句中的列；这与 sql_mode=only_full_group_by 不兼容使用GROUP BY 语句违背了 sql_mode=only_

MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法

lucky多多的博客

03-22

5万+

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column

参与评论您还未登录，请先登录后发表或查看评论

解决MySQL报出1055-Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated类型的错误

weixin_45775973的博客

07-29

4299

在Mysql（版本为8.0.25）中进行分组查询的时候，频繁报出如下的错误：

mysql group by 报错Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated c

wuxiaopengnihao1的博客

09-05

4263

这是MySQL8.0默认开启only_full_group_by模式导致的，该模式限定select后面跟的列，在group by后面必须要有。好了，以上是本文所有内容，希望对大家有所帮助，也希望大家对。多多支持，你们的支持是我创作的动力！：该方式重启mysql会失效。修改配置文件my.cnf。重启mysql即可。

mysql遇见Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre问题解决

axiaobaoa的博客

01-06

1万+

解决执行sql语句报错Expression #2 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 with sql_mode=only_full_group_by

解决Mysql：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated

qq_39954916的博客

09-06

4万+

SELECT 日期,地域,活跃度,COUNT(qq号) as qq个数 FROM (SELECT a.`日期`,a.`qq号`,a.`地域`,IF(b.msg>=200,'高活跃度','低活跃度') AS 活跃度 FROM table_user AS a LEFT JOIN table_act AS b ON a.`日期` = b.ftime AND a.qq号 = b.qq WHERE a.`地域` IN ('广东','广东省'))t GROUP BY 日期,活跃度; 以上代码运行报错.

mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...解决方案

最新发布

科技改变人类，技术成就未来

08-09

1万+

在使用 MySQL 时，可能会遇到这样的错误提示：“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column”。这通常是由于在 GROUP BY 查询中，SELECT 列表中的某些列没有被包含在 GROUP BY 子句中或没有使用聚合函数所导致的。本文将详细介绍这一错误的原因，并提供相应的解决方法。

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报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xx

健身变秃，coding变强

04-29

1万+

MySQL group by报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.test_baobiao.qty' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

mysql 报错解决思考Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column

zhangsir的博客

11-24

1万+

mysql报错： [Err] 1055 - Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘库名.表名.字段’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 分析发生这个错误，一般是

mysql使用group by不规范，导致SELECT list is not in GROUP BY clause and contains nonaggregated column

dyc_dyc的博客

03-06

2万+

select *,count(distinct fittings_list_code) from fittings_list where approval_status = '0' group by fittings_list_code 数据库查询操作大致如上（别问我为啥能写出来这么逗的数据库查询语句，反正就想对fittings_list_code这个字段去下重，用distinct+group...

SELECT list is not in GROUP BY clause and contains nonaggregated column

J_bean的博客

03-07

8261

报错 MySQL 8.0.22 GROUP BY 语句执行报错： 1055 - Expression #22 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxx.xxx.xxx' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_fu

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

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

山鬼谣的专栏

05-06

7219

环境 MySQL：8+ 在执行类似这样的语句时： SELECT * from template_detail a group by template_id; 然后报错了： 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ssm.template_detail.id' which is not functionally dependent on columns

MySQL报错 SELECT list is not in GROUP BY clause and contains nonaggregated column...

Main_1125的博客

01-15

9341

MySQL报错 SELECT list is not in GROUP BY clause and contains nonaggregated column… 原因：在mysql5.7以上的版本中，对于 group by 的这种聚合操作，如果在select 中的列，没有在group by 中出现，那么这个SQL是不合法的，因为列不在group by的从句中，所以对于设置了这个mode的数据库，在使用group by 的时候，就要用MAX()，SUM()，ANT_VALUE()的这种聚合函数，才能完成GR

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会不识别选择列表...

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

和代码死磕到底的博客

04-19

1万+

set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_F...

解决SELECT list is not in GROUP BY clause and contains nonaggregated column 'novle'

yyy2567338788的博客

01-21

2万+

使用MySQL，创建视图，SQL语句如下 SELECT `n`.`id` AS `novelID`, `n`.`name` AS `novelName`, `n`.`info` AS `introduction`, group_concat(`t`.`name` SEPARATOR ',') AS `novelType`, `n`.`author` AS ...

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo

bug如沙 , 汇成撒哈拉

09-21

1万+

说明情况: 首先我是在Linux服务器上新装了一个mysql , 原先版本为5.7.22 , 现在不小心装成了5.7.16 , 项目启动是时候跳转首页不显示数据 , 后台开始报错 : 如下 , 具体错误bug忘了复制截图 , 只保留了标题和下面这两行百度的内容 , 属于bug原因 Expression #1 of ORDER BY clause is ...