MySQL操作报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colu

原创 已于 2024-03-26 16:14:21 修改 · 2.1k 阅读 · 1 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
GEO检测
于 2024-03-25 14:21:37 首次发布
本文记录了在Mysql数据库操作中遇到的ORDERBY错误，源于sql_mode设置。解决方法是在my.cnf或my.ini中修改或添加配置，如`sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION`，以适应MySQL8的要求。
 前言：本文内容为实操记录，仅供参考！
问题：
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

解决方法：
在my.cnf或my.ini配置文件中修改或添加：

[mysqld]

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

说明：此方法可以解决大部分mysql8出现的上述报错，配置之后若不生效或启动错误需删除以上配置并需求新的解决方案。

标签
#mysql #数据库
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
yemuyouhan的博客
12-10 9849
在用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(全版本) - 报错 Expression 1 of ORDER BY clause is not in SELECT list,references column（详细解决教程）
✅ 精选推荐文章
04-13 4598
mysql，linux，centos，数据库，报错，出现错误，mysql升级版本报错，MYSQL更新版本后出现报错，数据库升级后都报错了，mySQL升级后都报错了，详细解决方案，Expression 1 of ORDER BY clause is not in SELECT list,references column，依然无法解决怎么办，MySQL遇到问题，当使用ORDER BY查询时,不能使用SELECT DISTINCT去重查询，mysql在进行多表关联出现报错，在mysql数据库中，遇到报错：Exp
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column...
weixin_42121675的博客
06-29 1万+
报错内容 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'xxx.table.column' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 问题分析： 出现的问题是由
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加索引或者删除索引时报了这个错。 两种解决方
mysql5.7 group报错ERROR 1055 (42000): Expression #1
Marhal的博客
03-27 849
ubuntu16.04 apache2.4 php7.0 mysql5.7 $order_goods=db('order_goods')->where('orderid','in',$_orderid_arr)->group('orderid')->having('id>0')->select(); echo db('order_goods')->getL...
MySQL报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colu
JaneYork的博客
02-17 1万+
1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fbjs.mscc.ContactTime' which is not functionally dependent on columns in GROUP BY clause; this is incom...
解决MySQL报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘informat
热门推荐
HaHa_Sir的博客
05-29 2万+
解决MySQL报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat一、问题描述新安装的MySQL5.7.22 或 8.0.11，在 Navicat 上执行删除操作时，遇到报错：[Err] 1055 - Expre............
MySql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
fxjzzyo的博客
07-09 3461
更新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报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
lalala_dxf的博客
06-28 1万+
这是数据库的sql_mode设置的有问题。Mysql可以支持不同的SQL模式，不同的SQL模式会有不同的语法，执行不同的数据校验简查。 MySQL5.7版本以上默认设置了 mysql sql_mode = only_full_group_by 属性，导致报错。第一步 查询结果为：第二步 去掉ONLY_FULL_GROUP_BY 重新设置值第三步 上面是改变了全局sql_mode 对于新建的数据库有效, 对于已存在的数据库，则需要在对应的数据下执行： window电脑修改mysql中的my.ini配置文件，
mysql 5.7 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colu...
weixin_30687587的博客
09-09 924
使用mysql在执行一条插入语句时 insert into channel(channel_id, channel_no,channel_name) values(1, '1000', "hhh"); 报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated...
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'inform
没有用户名的博客
03-20 1万+
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; thi
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘
Ethe的博客
08-24 229
【代码】Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘
解决mysql报错：- Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated co...
weixin_30625691的博客
05-07 192
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 GRO...
mysql - windows下my.ini和linux下my.cnf简单配置
qq_25598453的博客
03-26 4855
[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...
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains n
m0_37635053的博客
07-22 4819
[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...
mysql报错：ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
总结经验，与君共勉
12-05 1万+
在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 de...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated解决
mischen520的博客
01-09 2万+
今天docker容器中搭建mysql主从同步的时候，发现了如下报错： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated 问题背景： 使用的mysql数据库版本为：5.7 在从库中执行如下命令：start slave 然后就报如上错误 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY
mysql sql_mode小分享
王鹏的专栏
07-17 942
mysql sql_mode参数小节 mysql，sql实例SELECT charges,mealstime,name,sd_meal.id,fixedcharges,balancecharges,payablecharges FROM sd_meal,lcmemdata,sd_conservation WHERE sd_meal.childuid=lcmemdata.childi
报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregat
邵奈一的博客
12-30 2070
在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
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值