mysql报错-ORDER BY clause is not in GROUP BY clause and contains

最新推荐文章于 2024-03-25 14:21:37 发布
最新推荐文章于 2024-03-25 14:21:37 发布
阅读量3.4k 收藏 2
点赞数
CC 4.0 BY-SA版权
分类专栏： mysql 文章标签： ORDER BY clause is not in mysql information_schema
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/u012447287/article/details/90599543
博客讲述了在创建表时，MySQL出现'Expression #1 of ORDER BY clause...'报错的情况。原因是使用了类似Oracle的group规则，select列需在group中或为聚合列。作者去掉该配置，通过修改my.cnf配置文件并重启服务解决了问题。

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

在创建表时，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

这是因为使用这个就是使用和oracle一样的group 规则, select的列都要在group中,或者本身是聚合列(SUM,AVG,MAX,MIN) 才行，其实这个配置目前个人感觉和distinct差不多的，所以去掉就好 

参见:https://blog.youkuaiyun.com/fansili/article/details/78664267

本人使用第二共办法，修改my.cnf配置文件

vi /etc/my.cnf

[mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

service mysqld restart
 

解决问题><

 

mysql(全版本) - 报错 Expression 1 of ORDER BY clause is not in SELECT list,references column（详细解决教程）
高级前端工程师
04-13 4230
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
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
yemuyouhan的博客
12-10 9452
在用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...
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
赵大白
07-11 654
完整错误### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'a.add_...
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...
MySQL 之 ORDER BY clause is not in GROUP BY clause
dingxingmei的专栏
09-02 3028
055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'basedb.tcd.sale_day' which is not functionally dependent on columns in GROUP BY clause; this is inco...
ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROF
逗比爱好者
01-03 1199
ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROF：错误是从这里开始的，我百度了一下，有两种解决办法 1. 打开mysql查询命令输入 select version(), @@sql_mode;//这个是查看你配置的 SET sql_mod...
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘
weixin_45773788的博客
06-25 2667
执行带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异常:[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
m0_67393619的博客
06-08 709
时间：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
mysql5.7 group报错ERROR 1055 (42000): Expression #1
Marhal的博客
03-27 799
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...
ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘xxx.sxxx_.id‘ which is
hello world
01-06 1236
异常信息 2022-1-6 09:05:28 [http-nio-8092-exec-8] WARN [SqlExceptionHelper]:137 SQL Error: 1055, SQLState: 42000 2022-1-6 09:05:28 [http-nio-8092-exec-8] ERROR [SqlExceptionHelper]:142 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains non
ORDER BY clause is not in GROUP BY clause
persistence勿忘初心
06-30 5625
执行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...
mysql ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
三人行，必有我师焉。
11-24 888
mysql的sql_mode设置
MySQL操作报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colu
最新发布
蛤？
03-25 1991
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出现的上述报错，配置之后若不生效或启动错误需删除以上配置并需求新的解决方案。
【SQL】Group by 和Order By 后字段不一致引起的错误ORDER BY clause is not in GROUP BY clause
陶洲川的博客
04-15 2058
一、问题 1.1、环境 电脑环境：Windows 10； 开发工具：IntelliJ IDEA； 数据库环境：Redis 3.2.100 JDK环境: Jdk1.8； 1.2、问题 java.sql.SQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains no...
MySql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
fxjzzyo的博客
07-09 3303
更新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; 本文章记录了该问题的解决过程。
Expression #1 of ORDER BY clause is not in SELECT list,references column 'xxxxxxx'
热门推荐
涵山韵海的博客
04-23 2万+
给数据库升了个级，后台纷纷报错误： 报错信息： Expression #1 of ORDER BY clause is not in SELECT list, references column 'xxxx' which is not in SELECT list; this is incompatible with DISTINCT 问题原因： 　　mysql5.7.5及以上版本将s...
ORDER BY clause is not in GROUP BY clause and contains nonaggregated
09-29
ORDER BY clause is not in GROUP BY clause and contains nonaggregated column是MySQL中的一个报错信息。它表示在使用GROUP BY子句进行分组查询时，ORDER BY子句中的列没有包含在GROUP BY子句中，并且没有被聚合...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值