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

最新推荐文章于 2024-04-19 17:23:17 发布

原创最新推荐文章于 2024-04-19 17:23:17 发布 · 2.6k 阅读

4 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

9 篇文章

订阅专栏

本文详细介绍了在使用MySQL时遇到的'ONLY_FULL_GROUP_BY'错误，此错误源于SQL语句中的GROUP BY子句与ORDER BY子句不匹配。文章提供了一种简单有效的解决方法，即通过修改sql_mode来禁用ONLY_FULL_GROUP_BY模式，从而避免此类错误的发生。

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 GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

2.解决办法：在Navicat中输入

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

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

tangerine_

关注关注

4
点赞
踩
4

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

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

yemuyouhan的博客

12-10

9750

在用Navicat写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 depend...

MySQL建表时遇到的坑[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause...

qq_38732834的博客

06-07

562

我写了一个建表语句如下所示： CREATE TABLE IF NOT EXISTS `user`( id int NOT NULL auto_increment PRIMARY KEY , `name` VARCHAR(64) NOT NULL DEFAULT '', gender int NOT NULL DEFAULT '0' COMMENT '0男性，1女性', telphone VARCHAR(13) NOT NULL DEFAULT '', register_mode VARCHAR(

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

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 - windows下my.ini和linux下my.cnf简单配置

qq_25598453的博客

03-26

4820

[mysql] # 设置mysql客户端默认字符集 default-character-set=utf8 [mysqld] #设置3307端口 port = 3307 # 设置mysql的安装目录 basedir=G:\a_workIndex\mysql\mysql-5.7.24 # 设置mysql数据库的数据的存放目录 datadir=G:\a_workIndex\mysql\mysql-5...

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

weixin_38166557的博客

09-19

1129

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

己亥谷雨

02-22

3489

[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 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.youkuaiyun.com/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 ...

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

老刀

06-20

9120

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

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

afei8080的专栏

03-09

1771

MySql only_full_group_by规则

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

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

06-07

7124

MYSQL - sql_mode问题

weixin_30681121的博客

06-11

365

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

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

quliuwuyiz的博客

03-11

205

问题：[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 ...

MySQL 出现 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题

m0_43413873的博客

01-06

464

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

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

edwin_nj的博客

08-23

216

[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

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

ljj1036722396的博客

03-24

2018

问题：[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 ...

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

王永存

02-21

1133

MySQL错误Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colum

Janet_5的博客

07-24

2262

程序提示错误：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...

mysql 5.7分组报错问题 Expression #1 of ORDER BY clause is not in GROUP BY clause

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

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