linux下order by 报出ORDER BY clause is not in SELECT list

最新推荐文章于 2025-03-10 15:43:07 发布
最新推荐文章于 2025-03-10 15:43:07 发布
阅读量2k 收藏
点赞数
文章标签： 数据库
原文链接：http://www.cnblogs.com/hackxiyu/p/8675027.html
版权

一、问题：

　　在程序执行查询的时候，order by 不能找到要排序的列

 

二、解决：

　　在linux环境下，程序之前连接其他库可以正常运行，但是换了一个库后数据就不能正常的显示了，查看后台报出排序列找不到

　　在网上搜索教程后发现，需要在mysql里添加一个配置

转载于:https://www.cnblogs.com/hackxiyu/p/8675027.html

mysql(全版本) - 报错 Expression 1 of ORDER BY clause is not in SELECT list,references column（详细解决教程）
高级前端工程师
04-13 4011
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
MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法
热门推荐
lucky多多的博客
03-22 5万+
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
mysql报错ORDER BY clause is not in SELECT list, references column ‘‘which is not in SELECT list解决方案
cucgyfjklx的博客
07-07 1万+
mysql报错Expression #1 of ORDER BY clause is not in SELECT list, references column 'fusion.m.create_time' which is not in SELECT list; this is incompatible with DISTINCT解决方案
异常：Expression #2 of SELECT list is not in GROUP BY clause
最新发布
weixin_73060959的博客
03-10 743
优先选择。
ORDER BY clause is not in SELECT list
michael_linux的博客，一个小小小学生。滴水穿石，步步为营，只为那刹那芳华。
11-18 4134
Error querying database. Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘xxx-数据库.T1.sort’ which is not in SELECT list; this is incompatible with DISTINCT
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...
MySQL Expression 1 of ORDER BY clause is not in SELECT list,references column
04-12 2196
3、MySQL Server 默认开启了 sql_mode=only_full_group_by 模式，此模式要求 group by 字段必须出现在查询项中（select），否则就会报出该错误。mysql5.7版本中，如果DISTINCT和order by一起使用将会报3065错误，sql语句无法执行。在sql语句中使用DISTINCT时不使用order by进行排序，获取结果集后通过php进行数据的排序，同时也提高了mysql的性能。同时group by，limit和其中的一起搭配使用也会导致错误。
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查询的时候出现 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre报错
weixin_43140656的博客
11-28 753
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre …后面一大堆 出错就是这样 我们可以在网上看到很多解释 MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查...
Expression #1 of ORDER BY clause is not in SELECT list,
04-29
"Expression #1 of ORDER BY clause is not in SELECT list 是一个常见的SQL错误，它表示在ORDER BY子句中使用的表达式在SELECT列表中不存在。ORDER BY子句用于对查询结果进行排序。 通常，ORDER BY子句中的表达式...
Expression #1 of ORDER BY clause is not in SELECT list, this is incompatible with DISTINCT问题解决处理
weixin_53345642的博客
09-19 534
【mysql】Expression #1 of ORDER BY clause is not in SELECT list, this is incompatible with DISTINCT问题解决处理。
mysql linux下order by 报出ORDER BY clause is not in SELECT list
NRGAGA的专栏
06-02 1306
http://www.mamicode.com/info-detail-2238891.html 需要在mysql里添加一个配置
1 of ORDER BY clause is not in SELECT list, references column 'xxx' which is not in SELECT list
iam_syq的博客
11-25 1062
在linux系统上升级mysql后 查看日志原项目报错 通过查阅资料发现在mysql5.7.5及以上版本实现了对功能依赖的检测。默认启用了ONLY_FULL_GROUP_BY SQL模式。在该模式下， 将该sql语句放到Navicat中执行并不会报错，执行成功了。 在mysql5.7.5及以上版本实现了对功能依赖的检测。默认启用了ONLY_FULL_GROUP_BY SQL模式。在该模式下， 我...
MySQL 联表查询去重 & 解决 DISTINCT 异常：Expression #1 of ORDER BY clause is not in SELECT list, references...
指尖流连敲击梦想，代码行行承载远方！
09-08 2291
MySQL 联表查询去重 & 解决 DISTINCT 异常：Caused by: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'xxx.x.sort_num' which is not in SELECT list; this is incompatible with DISTINCT
Expression #1 of ORDER BY clause is not in SELECT list,references column ‘xxxxxxx‘（亲测有效，网上很多是有问题的）
LFpeter_的博客
11-08 1464
亲测有效！网上很多帖子有BUG，一直失败，最后终于弄好了。所以必须分享下，以免大家按照错误的帖子浪费时间！ 报错信息： 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及以上版本将sql_mode的ONLY_FULL_GROUP_BY模式
mysql5.7.5及以上版本使用ORDER BY 报错Expression #1 of ORDER BY clause is not in SELECT list, references colu
DN金猿的博客
05-24 392
Expression #1 of ORDER BY clause is not in SELECT list, references column 'X1.t0.name' which is not in SELECT list; this is incompatible with DISTINCT
Expression #3 of ORDER BY clause is not in SELECT list,references column ‘xx‘which is not in SELECT
qq_41340666的博客
07-07 858
参考:https://www.jb51.net/article/182846.htm Windows环境 mysql配置文件添加如下代码 [mysqld] sql-mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION 注意：[mysqld]必须加，且sql-mode中间是“-”，而不是下划线。 保存退出，重启服务器，即可永久生效。 ..
Caused by: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, reference
weixin_43232423的博客
01-12 3860
在公司出现以下Bug问题 所以开始研究为什么会出这个问题 找到网上说先执行这个命令 打开mysql客户端,输入 select @@global.sql_mode 查询出来的信息长这个样子 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION 再执行 set @@global.sql
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值