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

最新推荐文章于 2024-07-31 19:32:37 发布
最新推荐文章于 2024-07-31 19:32:37 发布
阅读量872 收藏
点赞数
文章标签： mysql 数据库 sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_31676483/article/details/116751515
版权
一、进入到数据库，输入以下代码；可以看到only_full_group_by;这个是mysql5.7以上新加入的，去掉即可

在这里插入图片描述

select @@sql_mode;
二、将显示的字符拷贝下来，因为数据库的原因，导致查询的sql-mode的值可能不一样，所以尽量以自己的查询结果为准；退出mysql；

退出服务net stop mysql
在这里插入图片描述

三、找到mysql的my.ini文件（一般在安装的mysql根目录中），添加内容到my.ini文件时，需要停止服务，添加完成后在开启服务；去掉only_full_group_by加上sql_mode;

在这里插入图片描述

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
四、重启mysql；
net start mysql
mysql -uroot -p

输入：select @@sql_mode;
可以看到only_full_group_by没有了
在这里插入图片描述

火红_
关注
解决[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
weixin_43520450的博客
03-15 3168
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
MySQL报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
澎湖Java架构师的博客
06-07 1144
时间：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 Error 1055: Expression #1 of ORDER BY clause is not in GROUP BY ...
乐杨俊浅谈LAMP
01-30 380
Error 1055: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'db.order.pay_at' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_grou
解决[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause andcontains nonaggregated
最新发布
weixin_54163986的博客
07-31 211
解决[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause andcontains nonaggregated column 'information schema.PROFlLING.SEQ' which isnot functionally dependent on columns in GROUP BY clause; this is incompatiblewith sql mode=only_full_grou
mysql 5.7之后 报错 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and ...
m0_37561039的博客
01-09 1168
具体错误是： [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...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
Quantum_Dog的博客
03-22 2127
转载：https://blog.csdn.net/caijian_/article/details/78628153 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ ...
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`子句中...
[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...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值