[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQL

最新推荐文章于 2024-10-11 07:30:00 发布

原创最新推荐文章于 2024-10-11 07:30:00 发布 · 198 阅读

0 ·

CC 4.0 BY-SA版权

MySQL 专栏收录该内容

9 篇文章

订阅专栏

本文探讨了MySQL5.7.5版本中默认开启的ONLY_FULL_GROUP_BY特性，该特性要求SELECT子句中的所有列必须出现在GROUP BY子句中，否则SQL语句将被视为不合法。文章提供了检查当前sql_mode设置的方法，并给出了两种禁用ONLY_FULL_GROUP_BY的解决方案。

查mysql文档得知，mysql从5.7.5开始默认开启ONLY_FULL_GROUP_BY：

对于GROUP BY聚合操作，如果在SELECT中的列，没有在GROUP BY中出现，那么这个SQL是不合法的，因为列不在GROUP BY从句中。

解决方法

1 show variables like "sql_mode";
2 set sql_mode='';
4 set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

Super-Henry

关注关注

0
点赞
踩
0

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

MySQL报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains

澎湖Java架构师的博客

06-07

1341

时间：2021年12月20日14:44:04 周一临近寒假，各科考试接踵而至，笔者今天考试的科目是MySQL，拿到了老师给的准备考试的文档，在Navicat中复制粘贴了之后，执行后突然报错：记录一下解决办法：错误代码显示： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ w

处理docker部署的mysql8在执行sql时报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause...

阿飞的博客

09-01

785

在配置mysql.cnf的[mysqld]内新增sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION 可长期有效。安装apt install vim 提示没有apt。然后问题又来了，docker内没有常用编辑工具vi、vim。-i ：直接修改读取的文件内容，而不是输出到终端。可本次mysql运行解决，重启mysql失效。......

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

解决：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQ

Allen . Liu

08-28

2880

[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 ...

MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains问题

最新发布

XING的博客

10-11

1493

会报下面的错误，Navicat版本较低造成的，不影响结果的显示，查询结果也是正确的。更新的Navicat版本，或者下载免费试用的最新版本，就不会有个错误提示了。使用Navicat连接MySQL数据库进行查询的时候，如果。MySQL的配置文件里增加。

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains 的问题 MySQL

yy050810的博客

03-16

251

mysql版本：8.0.16 navicat版本：11.1.3 执行update语句报错：MySql遇到 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ whi...

解决MySQL报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains ...

2201_76005298的博客

09-11

1602

1、解决办法：把 sql_mode中的 only_full_group_by 去掉即可。2、办法一（摘自这里只在当前查询页面有效，不能一次性解决问题！编辑 my.cnf： vim /etc/my.cnf 将上一步骤的 sql_mode 字段内容添加至 my.cnf。3、办法二：修改 my.cnf 文件的 sql_mode （一次性解决问题）获取 sql_mode字段内容： SELECT @@sql_mode;去掉 sql_mode字段中的 only_full_group_by。

windows安装 mysql5.7 ,客户端执行delete，update语句报错 [Err] 1055 - Expression #1 of ORDER BY claus...

qq445829096的博客

04-15

591

windows安装 mysql5.7 ,客户端执行delete，update语句报错 [Err] 1055 - Expression #1 of ORDER BY claus...

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`子句中...

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c

yemuyouhan的博客

12-10

9741

在用Navicat写MySQL命令时，出现以下错误： [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 depend...

MySQL建表时遇到的坑[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause...

qq_38732834的博客

06-07

560

我写了一个建表语句如下所示： CREATE TABLE IF NOT EXISTS `user`( id int NOT NULL auto_increment PRIMARY KEY , `name` VARCHAR(64) NOT NULL DEFAULT '', gender int NOT NULL DEFAULT '0' COMMENT '0男性，1女性', telphone VARCHAR(13) NOT NULL DEFAULT '', register_mode VARCHAR(

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

lmp5023的博客

11-18

366

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_f..

mysql 报 list is not in GROUP BY clause and contains nonaggre的问题

cainiaojan的博客

05-11

239

在my.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即可

解决SQL中的“Expression #1 of SELECT list is not in GROUP BY clause“错误

07-03

5万+

在日常开发中，我们经常会遇到SQL查询中的一些错误，尤其是在处理复杂的查询时。今天，默语将带大家一起深入探讨并解决一个常见的SQL错误：“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column”。通过这篇文章，您将了解该错误的原因及其解决方案，提升您的SQL技能。在SQL查询中，GROUP BY子句用于将结果集按一个或多个列进行分组。

【MYSQL】SELECT list is not in GROUP BY clause: mysql数据库异常解决方案

dkz97的博客

06-29

6730

SELECT list is not in GROUP BY clause: mysql数据库异常解决方案前言问题及需求解决方案合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入前言你好！这是你第一次使用 Markdown编辑器所展示的

mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic

A乐神的博客

12-15

8578

mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic

SELECT list is not in GROUP BY clause...

一起学习前端知识，一起成为前端开发工程师！

04-21

286

线上服务器数据库查询使用了 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 报错Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated c

wuxiaopengnihao1的博客

09-05

4225

这是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 nonaggregated column解决方法

m0_67882861的博客

11-07

6098

因为sno属性是主码，即primary key，经测试发现group by **，**为主码的属性名时，select语句中的查询列没有在group by中出现，也是允许的。红色部分可以发现sc.sno与studen.sno都没有在GROUP BY的列中，但执行语句依旧正常，因为使用了聚集函数。执行mysql语句，select 选择的列不仅仅只有sno，为什么正常输出？存书（书号，书名，出版社，版次，出版日期，作者，书价，进价，数量）现有两表Student表以及SC表(选课表)。student表结构。

mysql常见报错之SELECT list is not in GROUP BY clause

从兄的博客

05-21

1455

开发中使用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...

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains

09-02

- *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...