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

最新推荐文章于 2022-09-01 13:24:10 发布
最新推荐文章于 2022-09-01 13:24:10 发布
阅读量301 收藏
点赞数
分类专栏： database 文章标签： mysql
本文详细介绍了如何解决在MySQL中遇到的1055错误，即表达式在ORDER BY子句中不在GROUP BY子句中且包含非聚合列的问题。通过调整sql_mode设置，可以有效地解决这一兼容性问题。

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

问题：[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

解决方案：

dos root登录mysql

命令行敲入

SET sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';

 

 

 

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
赵大白
07-11 654
完整错误### 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
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
[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-1055错误 MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
LoweMuo_洛漠
09-18 7132
mysql-1055错误 MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 想着给数据库里插入一条测试数据，居然报错了可奇葩的是报错了数据居然还插入进去了。 看了一下原来是因为mysql版本的问题。。 在MySQL5.7之后，sql_mode中默认有一条ONLY_FULL_GROUP_BY，S...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
knight康康的博客
12-22 1440
数据库执行遇到的错误[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
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 753
在配置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
qq_42770949的博客
03-25 192
问题：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggre...
数据库Mysql报错： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and
法国锄头雨
07-05 804
解决方法如下 数据库执行： select version(), @@sql_mode;SET sql_mode=(SELECT REPLACE(@@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 869
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 nonaggregated
小屁孩大帅-保密的博客
10-18 648
[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 ...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated .
小马哥的天涯
03-13 299
处理方法 select version(), @@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Navicat报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clauseand contains nonaggr
热门推荐
ray_yang0420的博客
11-27 1万+
刚刚把Navicat安装好，新建了一个测试库，打算键个测试表，执行了建表语句，insert语句，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 i
解决[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
RuigeO的博客
01-17 486
1.切到etc目录下：cd /etc 2.查看内容：cat my.cnf 或 cat my.cnf more 可以看到sql_mode的值，这个值是我改过之后的值，没改之前是ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE或者没有sql_mdoe这个变量没有则需要添加即可。 3.修改文件：vi my....
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题
EricXiao666的博客
05-07 515
执行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 ...
[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...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值