Expression #1 of ORDER BY clause is not in GROUP BY 解决思路

最新推荐文章于 2023-03-09 17:35:37 发布

wlh_150568

最新推荐文章于 2023-03-09 17:35:37 发布

阅读量469

点赞数

分类专栏： mysql 开发常见问题

mysql 同时被 2 个专栏收录

4 篇文章 0 订阅

订阅专栏

开发常见问题

4 篇文章 0 订阅

订阅专栏

错误原因：

sql _mode中only _full _group _by不兼容的问题

解决思路：

由于是only _full _group _by不兼容，直接删除即可

show variables like "sql_mode"; 

set sql_mode='';
set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

wlh_150568

关注关注

0
点赞
踩
1

收藏

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

分享到 QQ

分享到新浪微博

扫一扫

专栏目录

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

m0_67393619的博客

06-08

613

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

weixin_43520450的博客

03-15

3279

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

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

weixin_38166557的博客

09-19

1050

MySQL[Err]1055 上次MySQL5.7.19主从建立完成之后，所有的测试都是在MySQL命令行下进行的，最近用Navicat Premium进行MySQL的连接，然后在插入数据的时候MySQL突然报错了，可是我的数据插入成功了，感觉很奇怪！！报错内容如下: [SQL]INSERT INTO biao(ziduan2) VALUES(8888888); 受影响的行: 1...

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

老刀

06-20

9020

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

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains n

m0_37635053的博客

07-22

4712

[Err] 1055 - ORDER BY子句的表达式#1不在GROUP BY子句中，并且包含非聚合列’information_schema.PROFILING '。SEQ’在功能上不依赖于GROUP BY子句中的列;这与sql_mode=only_full_group_by不兼容问题出现的原因： MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQ...

MySQL学习14_mysql执行sql语句提示Expression #1 of ORDER BY clause is not in GROUP BY

wang_zhenwei的博客

04-22

585

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

667

在配置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

afei8080的专栏

03-09

1641

MySql only_full_group_by规则

MYSQL---Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

JacksonKing的专栏

01-19

1094

--数据库中插入数据或执行sql语句时一直报下面这个错误： 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 c...

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

yuguang的博客

11-19

584

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

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'inform

热门推荐

没有用户名的博客

03-20

1万+

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; thi

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.

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

edwin_nj的博客

08-23

174

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

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

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

06-07

7068

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错误Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colum

Janet_5的博客

07-24

2074

程序提示错误：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 原因：数据库sq...

SQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated