Navicat报错：[Err] 1055 - Expression #1 ... incompatible with sql_mode=only_full_group_by

最新推荐文章于 2023-07-09 11:16:05 发布

宫懋鸡丁

最新推荐文章于 2023-07-09 11:16:05 发布

阅读量1.7k

点赞数 2

分类专栏： hadoop小白学习记录文章标签： navicat

本文链接：https://blog.youkuaiyun.com/Cui_maoxin/article/details/116942570

版权

在使用Navicat运行建表SQL时遇到[Err] 1055错误，而同样的语句在SQLyog中无误。错误源于sql_mode设置。临时解决方案是修改当前连接的sql_mode，永久解决则需修改my.ini文件中的sql_mode属性并重启MySQL服务。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

问题描述

今天使用Navicat连接mysql，运行建表sql后发现如下报错：

[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

最低0.47元/天解锁文章

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

宫懋鸡丁

关注关注

2
点赞
踩
8

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

mysql升级到5.7版本后，运行程序报错this is incompatible with sql_mode=only_full_group_by

Diamond_yoyo的博客

06-19

343

升级mysql后，运行程序报错 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘......’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 尝试

Navicate报错[Err] 1055

u014010996的博客

09-26

2915

Navicate报错[Err] 1055问题描述解决步骤1、查看错误信息，提示报错only_full_group_by，这个报错在执行查询时会出现；2、查看sql_mode（一组语法校验规则）对应的值；3、查看Mysql日志，在通用查询日志文件中，发现在新增的时候有查询INFORMATION_SCHEMA.PROFILING的操作;解决方法：关闭only_full_group_by规则；延申问题描述使用Navicate运行完insert语句，最后报错[Err] 1055 - Expression #1

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

Navicat执行sql报错 [Err] 1055 - Expression # 1 of ORDER BY clause is not in GROUP BY

Hehuyi_In的博客

12-10

4648

一、问题描述开发反馈Navicat无论执行什么语句都会有以下报错，不过实际能执行成功。 [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;

navicat上面的1055—Err问题

weixin_42220953的博客

08-31

2099

首先，网上很多的都是建议在navicat上面弄，但我真心失败过好几次，最后发现在mysql命令行上搞的首先Alt +R打开命令提示符输入net start mysql 然后 mysql -u root -p 输入密码进入mysql里面 mysql> SHOW SESSION VARIABLES; mysql> SHOW GLOBAL VARIABLES; mysql> select @@sql_mode; 然后重头戏来了 set global sql_mode=‘STRICT_T

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

最新发布

04-26

好的，用户现在遇到了在Navicat中执行DELETE语句后出现的1055错误，并且想了解sql_mode=only_full_group_by的影响及解决方案。根据用户提供的引用内容，特别是引用[1]、[3]、[4]都提到了1055错误与sql_mode的only_...

navicat使用mysql报错1055

m0_67677477的博客

05-27

398

在mysqld下输入sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION。不加使用Navicat建立存储过程又会报错。会无法启动mysql。

navicat在sql语句时，报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contai

那年的博客

11-23

855

问题：navicat在sql语句时，报错：[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 s

MySQL-[Err] 1055 - Expression #1

学亮编程手记

03-23

9930

问题描述：在MySQL数据库下，执行SQL插入语句报错。错误信息如下：错误原因：在MySQL5.7之后，sql_mode中默认存在ONLY_FULL_GROUP_BY，SQL语句未通过ONLY_FULL_GROUP_BY语义检查所以报错。 ONLY_FULL_GROUP_BY：ONLY_FULL_GROUP_BY要求select语句中查询出来的列必须是明确的（其他语句也是

Navicat 执行sql语句报错1055---of ORDER BY clause is not in GROUP BY

weixin_44529753的博客

04-06

1127

简单的说一下，遇到的问题是：当我执行一条insert语句会报错，但是不影响，但是当我执行多条语句的时候，就无法执行了。这是我的报错信息这是在MySQL5.7之后，sql_mode中默认存在ONLY_FULL_GROUP_BY，SQL语句未通过ONLY_FULL_GROUP_BY语义检查所以报错。更详细请看：MySQL1055 GROUP 第一种方法：在 Navicat中点击查询，新...

Navicat命令【use库名；】报错[err] 1055 处理方案记录

统计学+代码

04-12

1340

异常：在执行命令【use 库名;】时出现以下问题：问题：[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 incompatibl

navicat报错 1055 - Expression #1 of SELECT list is not in GROUP BY

Ben_zp的博客

09-11

991

背景在把代码部署到另一台服务器时，测试站没有问题的情况下，忽然sql爆了错，还是很吓人滴。具体完整的错误提示如下： 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zmw_jr1.360_imgs.id' which is not functionally dependent on columns in GROUP BY clause; this is in

Navicat报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clauseand contains nonaggr

ray_yang0420的博客

11-27

1万+

刚刚把Navicat安装好，新建了一个测试库，打算键个测试表，执行了建表语句，insert语句，SQL语句都执行了成功了，但是还是报错[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 i

this is incompatible with sql_mode=only_full_group_by

weixin_61873733的博客

04-14

1284

首先这是个SQL异常（org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar）导致我其中一个接口没有调取到数据，前端页面没有展示。这个错误是idea控制台报的。然后把SQL语句在Navicat 上进行测试修改。然后我在网上去百度，发现多数是说MySQL数据库5.7版本之后出现的。参考链接(12条消息) MySQL错误-this is incompatible with sql..

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

fxjzzyo的博客

07-09

3256

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

记一次group by报this is incompatible with sql_mode=only_full_group_by

m0_37772518的博客

09-01

252

group by查询语句： select fprojectid,fteamid,fprojectname,fdevmanage,ftestmanage,fcreateuser,fcreatetime,fupdatetime from t_project group by fprojectid; 报错：然后我用的是Navicat premium 可视化工具。查询mysql版本号：...