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

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

kin-liny

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

阅读量394

点赞数 1

文章标签： MySQL Java

本文介绍了解决MySQL中因sql_mode设置为ONLY_FULL_GROUP_BY导致的查询错误的方法。通过调整sql_mode，可以避免在使用非聚合列进行排序时出现的错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

这几天学习mysql时遇到不少问题，其中一个就是查询sql运行时会出现一个错误，但也有查询结果，在百度之后发现了一个有效的解决方法，下面是报错信息：[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

解决方案：

select version(),
@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

之后再运行

show variables like "sql_mode";

set sql_mode='';
set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';

然后再运行自己的sql就不会出现之前的错误了

原文链接：https://www.cnblogs.com/yaogengzhu/p/9570302.html

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

kin-liny

关注关注

1
点赞
踩
0

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

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

yemuyouhan的博客

12-10

9435

在用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报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains

m0_67393619的博客

06-08

709

时间：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

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

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

最新发布

XING的博客

10-11

1283

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

解决mysql报错：- Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated co...

diwei8531的博客

05-07

779

mysql执行报错： - 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 GRO...

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

2201_76005298的博客

09-11

1568

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。

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

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

阿飞的博客

09-01

752

在配置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失效。......

MySQL异常:[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona...

weixin_46245812的博客

11-24

1305

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 dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_..

mysql 8.0.1 提示1055错误。only_full_group_by问题

不积跬步无以至千里

09-17

9192

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

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

qq_43437122的博客

07-30

715

使用Navicat连接到MySQL（5.7版）执行插入操作时报了一个错误，如下： [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

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

热门推荐

mischen520的博客

01-09

1万+

今天docker容器中搭建mysql主从同步的时候，发现了如下报错： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated 问题背景：使用的mysql数据库版本为：5.7 在从库中执行如下命令：start slave 然后就报如上错误 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY

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

Buernnm的博客

07-04

2076

上述错误是因为mysql的配置文件不全或者错误导致的第一步查找mysql的配置文件 my.cnf linux 使用whereis my.cnf 或者 find / -name my.cnf 进行查找一般默认在/etc/my.cnf windows 1.第一种方法：在DOS命令行窗口登录MySQL，输入如下命令查看MySQL的安装目录和数据存放目录，MySQL的配置文件就在数据存放...

mysql5.7提示[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonag

shaofei_huai的博客

07-24

2252

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 dependent on columns in GROUP BY clause; this is incompatible with sql_mod...

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

邵奈一的博客

12-30

1947

在Navicat中执行SQL语句时，报以下错： [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 wi

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