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

最新推荐文章于 2024-10-11 07:30:00 发布

Flavoring

最新推荐文章于 2024-10-11 07:30:00 发布

阅读量2.6w

点赞数 41

分类专栏： mysql

本文链接：https://blog.csdn.net/gz530/article/details/99947417

版权

mysql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

解决办法：

第一种

执行sql 语句：

select version(),
@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

第二种：

修改配置文件 my.ini,在mysqld路径的下面增加代码：

添加或修改代码：

sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

Flavoring

关注关注

41
点赞
踩
32

收藏

觉得还不错? 一键收藏
10
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录

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

澎湖Java架构师的博客

06-07

1198

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

处理docker部署的mysql8在执行sql时报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause...

阿飞的博客

09-01

671

在配置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失效。......

10 条评论您还未登录，请先登录后发表或查看评论

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

1053

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 and contains问题

最新发布

XING的博客

10-11

324

会报下面的错误，Navicat版本较低造成的，不影响结果的显示，查询结果也是正确的。更新的Navicat版本，或者下载免费试用的最新版本，就不会有个错误提示了。使用Navicat连接MySQL数据库进行查询的时候，如果。MySQL的配置文件里增加。

MYSQL - sql_mode问题

weixin_30681121的博客

06-11

313

解决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

己亥谷雨

02-22

3426

[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

afei8080的专栏

03-09

1644

MySql 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

3300

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated

navivat输入sql语句报错[Err] 1055 - Expression #1 of ORDER BY clause

tangerine_的博客

01-30

2622

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 ...

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c

baidu_36882394的博客

04-24

6639

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c 异常：在执行一段SQL时出现以下问题 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and con...

MySql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr

fxjzzyo的博客

07-09

3099

更新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; 本文章记录了该问题的解决过程。

mysql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr...

weixin_30820077的博客

04-10

150

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 的问题

m0_43413873的博客

01-06

385

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

caohailan666的博客

01-21

163

[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’,’’)); ...

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY

希望我的博客，能帮上你解决学习中工作中所遇到的问题,也期待与您一起探讨技术问题，共同成长。

06-07

7068

mysql执行sql语句提示Expression #1 of ORDER BY clause is not in GROUP BY

老刀

06-20

9025

mysql 新版本出现group by 语句不兼容问题 [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 depen...