mysql Error 1055: Expression #1 of ORDER BY clause is not in GROUP BY ...

最新推荐文章于 2024-10-11 07:30:00 发布
原创 最新推荐文章于 2024-10-11 07:30:00 发布 · 486 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#sql #数据库

本文介绍了解决MySQL中Error1055错误的方法，该错误与sql_mode设置有关。文章提供了两种解决方案：一是临时修改sql_mode；二是通过配置文件进行永久修改。

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

一：背景

Error 1055: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'leyangjun_db.order.pay_at' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

二：原因

主要是数据库版本的问题

三：解决

查看命令：select @@sql_mode;

1:临时解决（机器重启后就会失效）

直接客户端指定命令：set global sql_mode='';

2：修改配置永久生效

修改 my.cnf 文件的 sql_mode，修改完配置记得重启MySQL

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
yemuyouhan的博客
12-10 9375
在用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...
SQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause异常处理
weixin_43811057的博客
02-16 294
如果结果中不包含 ONLY_FULL_GROUP_BY 就可以了。在查询下SELECT @@GLOBAL.sql_mode;如果结果中包含 ONLY_FULL_GROUP_BY。
MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains问题
XING的博客
10-11 1205
会报下面的错误，Navicat版本较低造成的，不影响结果的显示，查询结果也是正确的。更新的Navicat版本，或者下载免费试用的最新版本，就不会有个错误提示了。使用Navicat连接MySQL数据库进行查询的时候，如果。MySQL的配置文件里增加。
MySql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
fxjzzyo的博客
07-09 3282
更新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; 本文章记录了该问题的解决过程。
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains 的问题 MySQL
qq_15236137的博客
12-28 382
这几天学习mysql时遇到不少问题，其中一个就是查询sql运行时会出现一个错误，但也有查询结果，在百度之后发现了一个有效的解决方法，下面是报错信息：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema....
MYSQL - sql_mode问题
weixin_30681121的博客
06-11 337
解决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...
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 742
在配置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报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
澎湖Java架构师的博客
06-07 1310
时间：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 的问题
m0_43413873的博客
01-06 424
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';
MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
weixin_38166557的博客
09-19 1095
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
b_bunana的博客
04-24 1972
这是数据库报错 [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 G...
MySQL： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
己亥谷雨
02-22 3462
[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_gr.
当MYSQL遇到[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause问题
caohailan666的博客
01-21 190
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 解决办法 MySQL 解决办法： 执行sql 语句： 复制下面的语句直接在mysql中运行语句即可！ select version(), @@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,‘ONLY_FULL_GROUP_BY’,’’)); ...
MySQL5.7：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
qq_43437122的博客
07-30 713
使用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
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 1550
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。
Caused by: java.sql.SQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'tj_maihuo.maihuo_demand_audit.create_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
最新发布
05-22
### MySQL中 `sql_mode=only_full_group_by` 的兼容性问题 当 MySQL 数据库启用了 `sql_mode=only_full_group_by` 模式时，任何未聚合列如果不在 `GROUP BY` 子句中显式声明，则会引发 SQL 语法错误。这种模式是...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值