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

最新推荐文章于 2024-10-11 07:30:00 发布
最新推荐文章于 2024-10-11 07:30:00 发布
阅读量123 收藏
点赞数
分类专栏： mysql 常用问题 数据库 文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/joanzq/article/details/131597971
版权
mysql 同时被 3 个专栏收录
6 篇文章 0 订阅
订阅专栏
数据库
5 篇文章 0 订阅
订阅专栏
常用问题
2 篇文章 0 订阅
订阅专栏
当遇到MySql的[Err]1055错误，原因是由于sql_mode中的ONLY_FULL_GROUP_BY限制导致。解决方法是检查并修改SQL_MODE，移除ONLY_FULL_GROUP_BY。可以通过执行`SELECT@@sql_mode`查看模式，然后使用`SETsql_mode=(SELECTREPLACE(@@sql_mode,ONLY_FULL_GROUP_BY,));`来移除该模式。
摘要由CSDN通过智能技术生成

MySql插入数据成功但是报[Err] 1055错误的解决方案

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

sql_mode导致，去除only_full_group_by
解决方法：

– 查看SQL_MODE
SELECT @@sql_mode;

– 修改SQL_MODE
SET sql_mode=(SELECT REPLACE(@@sql_mode,‘ONLY_FULL_GROUP_BY’,‘’));

备注：REPLACE SQL中的替换函数

在这里插入图片描述

MySQL报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
m0_67393619的博客
06-08 618
时间：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 3304
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
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 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 and contains问题
最新发布
XING的博客
10-11 332
会报下面的错误，Navicat版本较低造成的，不影响结果的显示，查询结果也是正确的。更新的Navicat版本，或者下载免费试用的最新版本，就不会有个错误提示了。使用Navicat连接MySQL数据库进行查询的时候，如果。MySQL的配置文件里增加。
解决MySQL报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains ...
2201_76005298的博客
09-11 342
1、 解决办法： 把 sql_mode中的 only_full_group_by 去掉即可。2、 办法一 （摘自 这里 只在当前查询页面有效，不能一次性解决问题！编辑 my.cnf： vim /etc/my.cnf 将上一步骤的 sql_mode 字段内容添加至 my.cnf。3、办法二： 修改 my.cnf 文件的 sql_mode （一次性解决问题）获取 sql_mode字段内容： SELECT @@sql_mode;去掉 sql_mode字段中的 only_full_group_by。
mysql5.7提示[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonag
shaofei_huai的博客
07-24 2201
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; this is incompatible with sql_mod...
MySql5.7[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
ForeverAnt的博客
09-25 386
如题。MySQL5.7每次执行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 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失效。......
当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’,’’)); ...
Navicat执行sql报错 [Err] 1055 - Expression # 1 of ORDER BY clause is not in GROUP BY
Hehuyi_In的博客
12-10 4073
一、 问题描述 开发反馈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;
MySql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
fxjzzyo的博客
07-09 3100
更新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; 本文章记录了该问题的解决过程。
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains ......
蟹蟹肉的博客
10-25 1022
在 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 depende...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains 的问题 MySQL
qq_15236137的博客
12-28 347
这几天学习mysql时遇到不少问题，其中一个就是查询sql运行时会出现一个错误，但也有查询结果，在百度之后发现了一个有效的解决方法，下面是报错信息：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema....
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and ...解决办法
小婷
12-13 839
执行 sql语句 select version(), @@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); sql_mode是个很容易被忽视的变量，默认值是空值，在这种设置下是可以允许一些非法操作的，比如允许一些非法数据的插入。在生产环境必须将这个值设置为严格模式，所以开...
报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregat
邵奈一的博客
12-30 1830
在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 wi
Linux-插入数据异常报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause...
程序员精进之路
08-30 2633
在工具端执行数据插入操作时报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and...,但是数据还是插入成功了。可以肯定sql语句没有问题，于是就查看linux下的mysql配置问题。 解决办法： 1.打开mysql配置文件，加入如下配置，如果配置文件中存在请修改即可。 vim my.c...
MySQL 异常 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregat
weixin_42595573的博客
03-15 417
[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 ...
[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 dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by”。根据错误信息，这个错误是由于在ORDER BY子句中的列不在GROUP BY子句中，并且包含了非聚合的列。解决这个错误的方法是修改查询语句，将ORDER BY中的列添加到GROUP BY子句中或者使用聚合函数对ORDER BY列进行聚合。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值