数据库Mysql报错： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and

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

法国锄头雨

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

阅读量802

点赞数 1

本文链接：https://blog.youkuaiyun.com/weixin_43530295/article/details/107145963

版权

本文提供了解决MySQL中ONLY_FULL_GROUP_BY限制的方法，包括在Windows下通过SQL语句临时禁用，以及在Linux环境下永久修改配置文件。适用于需要调整数据库查询行为的场景。

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

解决方法如下

【Windows】数据库执行：

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

【Linux】修改mysql配置文件 vim /etc/my.cnf ，修改sql_mode的值，去掉ONLY_FULL_GROUP_BY

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

service mysqld restart

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

法国锄头雨

关注关注

1
点赞
踩
0

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

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

赵大白

07-11

645

完整错误### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'a.add_...

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

澎湖Java架构师的博客

06-07

1304

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

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

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

热门推荐

zq33312757的博客

11-10

1万+

[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

weixin_38166557的博客

09-19

1094

MySQL[Err]1055 上次MySQL5.7.19主从建立完成之后，所有的测试都是在MySQL命令行下进行的，最近用Navicat Premium进行MySQL的连接，然后在插入数据的时候MySQL突然报错了，可是我的数据插入成功了，感觉很奇怪！！报错内容如下: [SQL]INSERT INTO biao(ziduan2) VALUES(8888888); 受影响的行: 1...

mysql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr...

weixin_30820077的博客

04-10

182

mysql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated 今天迁移django数据库的时候，跑程序的时候出现这样的错误： [Err] 1055 - Expression #1 of ORDE...

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

736

在配置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 and contains nonaggregated c

yemuyouhan的博客

12-10

9326

在用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 - sql_mode问题

weixin_30681121的博客

06-11

336

解决SQL：SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); sql_mode常用值如下： ONLY_FULL_GROUP_BY 对于GROUP BY聚合操作，如果在SELECT中的列，没有在GROUP BY中出现，那么这个SQL是不合法的，因为列不在GROUP BY从句中。在严格模式下，不要让GRO...

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

qq_15236137的博客

12-28

381

这几天学习mysql时遇到不少问题，其中一个就是查询sql运行时会出现一个错误，但也有查询结果，在百度之后发现了一个有效的解决方法，下面是报错信息：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema....

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

希望我的博客，能帮上你解决学习中工作中所遇到的问题,也期待与您一起探讨技术问题，共同成长。

06-07

7093

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

最新发布

XING的博客

10-11

1051

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

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

qq_43437122的博客

07-30

712

使用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

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

m0_43413873的博客

01-06

420

MySQL 出现 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题第一步： show variables like "sql_mode"; 第二步： set sql_mode=''; 第三步： set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';

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

邵奈一的博客

12-30

1923

在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

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

shaofei_huai的博客

07-24

2247

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

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

2201_76005298的博客

09-11

1508

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

Ask Self，Ask Tomorrow

05-10

865

select version(); # 5.7.17常规查询报错： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column Trouble shooting过程（注意mysql5.7配置文件的路径）：root@TESTDB:~# cd / ro

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