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

最新推荐文章于 2024-03-25 14:21:37 发布
最新推荐文章于 2024-03-25 14:21:37 发布
阅读量172 收藏
点赞数
分类专栏： mysql 文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yy050810/article/details/104900706
版权

mysql版本：8.0.16

navicat版本：11.1.3

执行update语句 报错：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_mode=only_full_group_by

尝试在my.ini文件中配置sql_mode没有用

解决方法：

cmd

mysql -hlocalhost -uroot -p回车 输入密码 进入mysql命令行

输入：mysql> select @@sql_mode; 

查询结果： sql_mode=only_full_group_by……（后省略）

输入：set @@global.sql_mode ='';

执行结果：1 row in set

关闭重新打开navicat 执行之前的报错语句 不再报错1055

 

 

 

yy050810
关注
专栏目录
MySQL报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
m0_67393619的博客
06-08 616
时间：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失效。......
关于MySQL执行创建表命令后出现1055错误的解决办法--Expression #1 of ORDER BY clause is not in GROUP BY clause and contain
冰河的博客
12-16 6325
关于MySQL执行创建表命令后出现1055错误的解决方法问题描述解决办法 问题描述 如下例子： CREATE TABLE t( `deptno` INT(4), `dname` VARCHAR(255), `loc` varchar(255) ); 当执行这段代码时，navicat执行成功但是会报出1055错误，如下图所示 错误信息如下： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and cont
MySQL操作报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colu
最新发布
蛤？
03-25 1206
Mysql数据库操作报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat。这个问题主要是由于sql_mode引起，所以先查看sql_mode 然后修改即可，主要是去除only_full_group_by。说明：此方法可以解决大部分mysql8出现的上述报错，配置之后若不生效或启动错误需删除以上配置并需求新的解决方案。
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...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
yeying_bing的博客
12-24 3694
[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
、Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘infor
TheOne的博客
02-26 262
linux上mysql在插入数据报错，错误信息如下 、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
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`子句中...
解决[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
weixin_43520450的博客
03-15 3303
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
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 n
m0_37635053的博客
07-22 4715
[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...
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
YUAYU博客
12-29 3585
报错： Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.tables.DATA_LENGTH’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_b
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘
weixin_45773788的博客
06-25 2607
执行带group by的SQL语句出现如下错误：ERROR1055：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'db.tb_list.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_g
mysql - windows下my.ini和linux下my.cnf简单配置
qq_25598453的博客
03-26 4759
[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报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat...
weixin_30336061的博客
02-19 723
解决MySQL报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat 转自：https://blog.csdn.net/HaHa_Sir/article/details/80503601 2018年05月29日 23:10:52HaHa_Sir...
mysql Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona
weixin_30598225的博客
08-30 2689
1. 操作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 depen...
执行MySQL语句出现1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr...
独乐乐不如众乐乐
04-22 351
在Navicat中执行MySQl语句或者创建库和表时出现这种错误 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升级到5.7.16 遇到的第一个问题"[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and"
热门推荐
测试喵~
11-15 3万+
升级之后马上体验了一下，执行“UPDATE user_course SET userid = 200 WHERE id = 28;”，结果报[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROF...
数据库添加数据时报错1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregat
Lchen_kk的博客
03-21 433
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
09-02
- *1* [MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona...](https://download.csdn.net/download/weixin_38742656/13685329)[target="_blank" data-report...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值