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

最新推荐文章于 2023-07-09 11:16:05 发布
原创 最新推荐文章于 2023-07-09 11:16:05 发布 · 257 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#1024程序员节

这篇博客主要介绍了如何处理MySQL查询时遇到的错误：1055错误，该错误提示ORDER BY子句中的列不在GROUP BY子句中，且包含非聚合列。解决方案是修改MySQL的sql_mode设置，具体步骤为找到my.cnf配置文件，添加指定的sql_mode行，并重启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 dependent on columns in GROUP BY clause; this is incompatible with sql_mode

解决方案：

找到my.cnf文件，Linux上默认在etc/中，vi打开编辑器，在[mysqld]输入

sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION’

重启mysql服务即可

MySQL建表时遇到的坑[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause...
qq_38732834的博客
06-07 560
我写了一个建表语句如下所示： 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
weixin_38166557的博客
09-19 1125
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 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`子句中...
MySQL报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
澎湖Java架构师的博客
06-07 1341
时间：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 785
在配置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失效。......
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
cjg2522的博客
12-23 269
ORDER BY clause is not in GROUP BY
MySql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
fxjzzyo的博客
07-09 3344
更新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; 本文章记录了该问题的解决过程。
解决mysql报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
b_bunana的博客
04-24 1990
这是数据库报错 [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 G...
Mysql问题：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
afei8080的专栏
03-09 1760
MySql only_full_group_by规则
mysql运行时报[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
海边凝望的博客
03-23 273
2、在mysqld后面加入一句：sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION。在mysql安装目录下找到my.ini文件，右击打开。1、需要修改my.ini文件。3.重启mysql服务器。
MySQL报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
qq_42770949的博客
03-25 212
问题：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggre...
[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 ...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值