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

最新推荐文章于 2023-03-09 17:35:37 发布
最新推荐文章于 2023-03-09 17:35:37 发布
阅读量556 收藏
点赞数
分类专栏： 面试 学习路线 阿里巴巴 文章标签： mysql 数据库 database csrf json
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_67393619/article/details/125194061
版权
本文详细介绍了在MySQL 8中遇到错误1055的解决方法，该错误涉及ORDER BY与GROUP BY子句的不兼容性。通过修改MySQL配置文件实现永久性解决方案，避免切换到旧版本。
摘要由CSDN通过智能技术生成

【mysql报错1055 报错解决办法】[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

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

最低0.47元/天 解锁文章
小东西的东西
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
QQ657205470的博客
12-04 672
该错误是因为MySQL启用了模式，该模式要求在使用GROUP BY语句时，SELECT中的字段必须是聚合函数或者在GROUP BY子句中列出的字段。如果在SELECT中包含了非聚合字段而没有在GROUP BY中列出，就会出现这个错误。
MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
12-14
[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 在navicat中使用mysql加索引或者删除索引时报了这个错。 两种解决方
MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
weixin_38166557的博客
09-19 1015
MySQL[Err]1055 上次MySQL5.7.19主从建立完成之后，所有的测试都是在MySQL命令行下进行的，最近用Navicat Premium进行MySQL的连接，然后在插入数据的时候MySQL突然报错了，可是我的数据插入成功了，感觉很奇怪！！ 报错内容如下: [SQL]INSERT INTO biao(ziduan2) VALUES(8888888); 受影响的行: 1...
[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.csdn.net/download/weixin_38742656/13685329)[target="_blank" data-report...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
最新发布
09-15
这是一个MySQL查询错误，错误信息为“[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally ...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains 的问题 MySQL
qq_15236137的博客
12-28 320
这几天学习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 299
解决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...
MySQL5.7：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
qq_43437122的博客
07-30 645
使用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 and contains nonaggr...
weixin_30820077的博客
04-10 121
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
法国锄头雨
07-05 752
解决方法如下 数据库执行： 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
afei8080的专栏
03-09 1611
MySql only_full_group_by规则
MySQL 出现 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题
m0_43413873的博客
01-06 365
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 and contains
StrongTeacher的博客
11-17 633
使用Navicat连接数据库进行查询的时候，如果Navicat版本较低，MySQL数据库又5.7以上的版本，会报下面的错误，Navicat版本较低造成的，不影响结果的显示，查询结果也是正确的。 [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 funct
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值