用来记录我学习中出现过的问题[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause this is ...

最新推荐文章于 2024-06-12 22:18:06 发布
最新推荐文章于 2024-06-12 22:18:06 发布
阅读量387 收藏 7
点赞数 7
文章标签： 学习
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_53696702/article/details/135158709
版权

电脑突然卡住重启后再运行出现了这个错误

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

最开始学习时出现过一次，那时解决了以为不会再出现就没记录，结果卡后重启又发生，所以记录一下。

因为出现过一次，所以我按照最开始的思路，先检查我的my.ini重启后有没有变动。但我发现这一块没有问题

于是，我到命令端尝试关闭、重启mysql。发现可以关闭但是无法开启

到这里我反应过来，立马到服务里去查看我的mysql服务。

然后想起来，我安装了两个mysql服务，8.0.25和8.0.26。第一次出现这个问题操作的时候没有把8.0.26彻底禁用导致重启后它自动开启，于是这次我将它停止并禁用。

然后再次去Mysql执行命令的时候就没有这个错误了

我最大的问题就是安装了两个mysql服务

Haven.w
关注
  • 7
    点赞
  • 踩
  • 7
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
MySQL报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
野马菲比的博客
12-20 4万+
【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 sq
MySql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
fxjzzyo的博客
07-09 2193
更新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 nonaggregated
qq_51528941的博客
03-02 645
linux系统下的MySQL，在Navicat上运行sql文件最后出现的错误。
mysql [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause ...问题
Flychuer的专栏
12-04 836
在navicat中执行create table语句时报错： [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 incompat
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
Wolf__king的博客
11-14 1331
[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
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
cjg2522的博客
12-23 191
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解决
热门推荐
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
MySQL8.0.30执行语句异常:1055 - Expression #1 of ORDER BY clause is not in GROUP BY 解决方案
天涯芳草
08-19 296
MySQL8.0.30执行语句异常:1055 - Expression #1 of ORDER BY clause is not in GROUP BY 解决方案
MySql查询错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY...
Stargazer（仰望星空）的博客
10-09 2823
MySql报错原因解决方案sql_mode常用参数 原因 报错信息： [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 incom
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 ...
libcom_err-devel-1.42.9-19.el7.i686.rpm
07-06
libcom_err-devel-1.42.9-19.el7.i686.rpm
libcom_err-1.41.12-24.el6.x86_64.rpm
10-08
centos6，linux系统，rpm资源：libcom_err-1.41.12-24.el6.x86_64.rpm
libcom_err-devel-1.45.6-1.el8.aarch64.rpm
12-21
官方离线安装包，亲测可用。使用rpm -ivh [rpm完整包名] 进行安装
libcom_err-1.42.9-13.el7.x86_64.rpm
11-30
离线安装包，亲测可用
【电子信息工程专业课】学习记录
最新发布
共同进步！
06-12 292
- # **数字信号处理** * ## 离散时间信号与系统 + ### 周期延拓 一个连续时间信号经过理想采样后，其频谱将沿着频率轴以采样频率Ωs = 2π / T 为间隔而重复。 + ### 混频 各周期的延拓分量产生频谱交替的现象 + ### 奈奎斯特采样定理 fs > 2fh
Qt---pro文件的学习
weixin_51883798的博客
06-11 465
【代码】Qt---pro文件的学习。
怎么学习汇川Codesys PLC教程？
NAV3055的博客
06-12 304
各位好，我在B站和抖音上都有发布视频的，搜索我的名称“阿凡工控分享”即可。在CSDN上发表文章也是想把我的一点见解和经验分享出来，进一步的方便大家进行学习。
Nginx学习笔记（十）如何配置HTTPS协议？（公网）
ACGkaka的博客
06-10 714
Nginx学习笔记（十）如何配置HTTPS协议？（公网）
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
09-02
、和[3]引用的内容都是关于MySQL报错1055的问题。这个错误是由于在使用ORDER BY子句时，ORDER BY子句中的列没有在GROUP BY子句中，并且包含了不是在GROUP BY子句中的列，这与sql_mode=only_full_group_by选项不兼容所导致的。换句话说，这个错误是由于使用了不合法的ORDER BY子句。 要解决这个问题，可以有以下几种方法： 1. 修改SQL查询语句，确保ORDER BY子句中的列都在GROUP BY子句中，并且不包含不在GROUP BY子句中的列。这样可以确保查询语句符合sql_mode=only_full_group_by选项的要求。 2. 修改MySQL配置文件，将sql_mode选项中的only_full_group_by选项去掉。这样可以关闭只允许全面GROUP BY的模式，但需要注意这可能会导致其他潜在的问题。 3. 升级MySQL版本到5.7.5或更高的版本。从MySQL 5.7.5开始，sql_mode=only_full_group_by成为默认设置，不再允许ORDER BY子句中的非聚合列。 请根据具体情况选择适合的解决方法来解决[Err] 1055的问题。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *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-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *2* [[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated...](https://blog.csdn.net/miachen520/article/details/122390084)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *3* [[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains](https://blog.csdn.net/qq_43514711/article/details/122041247)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值