MYSQL异常Expression #1 of ORDER BY clause is not in GROUP BY clause 解决办法 MySQL

最新推荐文章于 2023-01-30 09:53:48 发布
最新推荐文章于 2023-01-30 09:53:48 发布
阅读量400 收藏
点赞数
分类专栏： mysql 文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_40811171/article/details/103947755
版权 
查看版本：select version()
查看规则： SHOW VARIABLES LIKE '%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 sql_mode = '';
set sql_mode = 'NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';
小小鸟敲代码
关注
专栏目录
mysql(全版本) - 报错 Expression 1 of ORDER BY clause is not in SELECT list,references column（详细解决教程）
高级前端工程师
04-13 3080
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
weixin_43520450的博客
03-15 3169
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
赵大白
07-11 599
完整错误### 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_...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQL
王永存
02-21 990
问题：[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 ...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause...
pansanday的专栏
07-11 1万+
问题描述: 在mysql客户端执行delete删除语句时，报出了以下错误： [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 func
MySQL 之 ORDER BY clause is not in GROUP BY clause
dingxingmei的专栏
09-02 2945
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...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
innerpeaceScorpio的博客
07-06 2万+
   &a
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 578
时间：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
Expression #1 of HAVING clause is not in GROUP BY clause and contains nonagg问题解决
DayDayUp
02-18 674
控制台报SQL按组查询相关错误：Expression #1 of HAVING clause is not in GROUP BY clause and contains nonagg，问题解决是在查询工具中将组策略修改。
mysql报错-ORDER BY clause is not in GROUP BY clause and contains
优弧的博客
05-27 3422
在创建表时，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 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
qq_41399976的博客
05-31 210
解决这个问题有一个办法，就是修改my.conf 在[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 然后重启MySQL服务就可以了 ...
MySQLSyntErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains n
weixin_45525601的博客
04-11 216
mysql执行的时候提示错误； 产生原因：mysql sql_mode导致 查看自己的sql_mode属性：select @@sql_mode 解决方法：1.set @@sql_mode =‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGI...
MySQL：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY with sql_mode=only_full_group
经验之谈，不做搬运工
08-01 215
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...
mysql Error 1055: Expression #1 of ORDER BY clause is not in GROUP BY ...
乐杨俊浅谈LAMP
01-30 381
Error 1055: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'db.order.pay_at' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_grou
MySQL错误Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colum
Janet_5的博客
07-24 2045
程序提示错误：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 原因：数据库sq...
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...
MySQL异常：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr...
weixin_33699914的博客
03-02 59
2019独角兽企业重金招聘Python工程师标准>>> ...
数据库错误ERROR 1055 (42000): Expression #1 of ORDER BY clause is not in GROUP BY
weixin_51418516的博客
04-01 1155
用的这篇文章的方法解决滴： https://blog.csdn.net/jgj0129/article/details/53420574 这里就是自己再记录一下。加粗的就是用到的语句。 mysql> select dept_name,avg(tot_cred) from student -> group by dept_name having avg(tot_cred)>80 order by(tot_cred) desc; ERROR 1055 (42000): Expression #
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 解决办法 MySQL
最新发布
10-10
在 MySQL 中，当你在使用 GROUP BY 子句时，如果在 SELECT 语句中包含了其他列，那么这些列必须被包含在 GROUP BY 子句中或者通过聚合函数进行处理。否则，将会出现 "Expression #1 of ORDER BY clause is not in GROUP BY clause" 的错误。 解决办法之一是，将非聚合列添加到 GROUP BY 子句中。例如，假设你有一个名为 "table_name" 的表，其中包含列 "column1" 和 "column2"。你可以使用以下查询来解决这个问题： ```sql SELECT column1, column2 FROM table_name GROUP BY column1, column2 ORDER BY column1; ``` 这样，你就将 "column1" 和 "column2" 添加到了 GROUP BY 子句中，并且可以按照 "column1" 进行排序。 如果你不想将非聚合列添加到 GROUP BY 子句中，你可以使用聚合函数来处理它们。例如，假设你只想按照 "column1" 进行排序，可以使用 MAX() 函数来处理 "column2"： ```sql SELECT column1, MAX(column2) AS max_column2 FROM table_name GROUP BY column1 ORDER BY column1; ``` 通过将 "column2" 使用 MAX() 函数进行聚合，你可以在不将其添加到 GROUP BY 子句中的情况下按照 "column1" 进行排序。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值