mysql 1130错误 和1055 - Expression #1 of ORDER BY clause is not in GROUP BY

最新推荐文章于 2025-06-05 18:57:40 发布
原创 最新推荐文章于 2025-06-05 18:57:40 发布 · 3.1k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql

 解决这问题就挺简单的，就是没有权限。

 1 登陆mysql

  

mysql -uroot -p

 2修改权限

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'121.25.33.55' IDENTIFIED BY 'password' WITH GRANT OPTION;





下面这个是解决5.7版本以上的mysql ，运行低版本mysql时候的错误


select version(), @@sql_mode;
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

第一步，搜索mysql sql_mode.,列出所有的

第二不，删除（替换）下面这个sql_mode

ONLY_FULL_GROUP_BY

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报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
澎湖Java架构师的博客
06-07 1317
时间：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 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：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
最新发布
plpldog的博客
06-05 533
（不信的可以试试，默认的sql_mode你在自增主键列设置为0，该字段会自动变为最新的自增值，效果和null一样），如果用户希望插入的值为0（不改变），该列又是自增长的，那么这个选项就有用了。在[mysqld]下添加sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'，然后保存并重启服务。不设置此值时，用默认的存储引擎替代，并抛出一个异常。
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated..
zq33312757的博客
11-10 1万+
[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
问题：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregate
qq_38448815的博客
03-14 301
问题：[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 ...
Expression #1 of ORDER BY clause is not in SELECT list, references column ‘d.dept_no‘ which is not i
m0_46458132的博客
02-09 1783
问题：添加distinct报错 原因：mysql5.7.5及以上版本将sql_mode的ONLY_FULL_GROUP_BY模式默认设置为打开状态时，导致：使用order by的时候不能用distinct 解决： set global 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异常:[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`子句中...
处理docker部署的mysql8在执行sql时报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause...
阿飞的博客
09-01 752
在配置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 and contains nonaggregated c
yemuyouhan的博客
12-10 9443
在用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...
1 of ORDER BY clause is not in SELECT list, references column 'xxx' which is not in SELECT list
iam_syq的博客
11-25 1072
在linux系统上升级mysql后 查看日志原项目报错 通过查阅资料发现在mysql5.7.5及以上版本实现了对功能依赖的检测。默认启用了ONLY_FULL_GROUP_BY SQL模式。在该模式下， 将该sql语句放到Navicat中执行并不会报错，执行成功了。 在mysql5.7.5及以上版本实现了对功能依赖的检测。默认启用了ONLY_FULL_GROUP_BY SQL模式。在该模式下， 我...
Caused by: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, reference
weixin_43232423的博客
01-12 3883
在公司出现以下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
Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list
u014212540的博客
01-17 1100
Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list
Expression #1 of ORDER BY clause is not in SELECT list, references column 'ekbX1.t0.name' which is n
qq_25983579的博客
03-16 9538
报错信息： Expression #1 of ORDER BY clause is not in SELECT list, references column 'ekbX1.t0.name' which is not in SELECT list; this is incompatible with DISTINCT 问题原因： mysql5.7.5及以上版本将sql_mode的ONLY_FUL...
mysql异常java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list
love_live2的博客
03-22 936
网上查了一下这个是因为数据库开启了only_full_group_by规则校验，执行命令关闭校验就恢复了。最近运维同学升级了数据库后，我们的程序很多接口都报错了一查看是数据库脚本执行报错。执行命令如果不生效的话可能需要重启mysql数据库或者重启服务试试。
MySQL报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
qq_42770949的博客
03-25 192
问题：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggre...
数据库Mysql报错： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and
法国锄头雨
07-05 804
解决方法如下 数据库执行： select version(), @@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
mysql-1055错误 MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
LoweMuo_洛漠
09-18 7132
mysql-1055错误 MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 想着给数据库里插入一条测试数据，居然报错了可奇葩的是报错了数据居然还插入进去了。 看了一下原来是因为mysql版本的问题。。 在MySQL5.7之后，sql_mode中默认有一条ONLY_FULL_GROUP_BY，S...
java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘me
qq_38314062的博客
11-16 2496
报错信息： The error may involve defaultParameterMap The error occurred while setting parameters SQL: select distinct master_order_id as masterOrderId,order_status as orderStatus,rider_id as riderId from st_order where gk_id = ? AND pay_status = 1 and payment_t
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
09-02
、和[3]引用的内容都是关于MySQL报错1055的问题。这个错误是由于在使用ORDER BY子句时，ORDER BY子句中的列没有在GROUP BY子句中，并且包含了不是在GROUP BY子句中的列，这与sql_mode=only_full_group_by选项不兼容所导致的。换句话说，这个错误是由于使用了不合法的ORDER BY子句。 要解决这个问题，可以有以下几种方法： 1. 修改SQL查询语句，确保ORDER BY子句中的列都在GROUP BY子句中，并且不包含不在GROUP BY子句中的列。这样可以确保查询语句符合sql_mode=only_full_group_by选项的要求。 2. 修改MySQL配置文件，将sql_mode选项中的only_full_group_by选项去掉。这样可以关闭只允许全面GROUP BY的模式，但需要注意这可能会导致其他潜在的问题。 3. 升级MySQL版本到5.7.5或更高的版本。从MySQL 5.7.5开始，sql_mode=only_full_group_by成为默认设置，不再允许ORDER BY子句中的非聚合列。 请根据具体情况选择适合的解决方法来解决[Err] 1055的问题。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona...](https://download.youkuaiyun.com/download/weixin_38742656/13685329)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *2* [[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated...](https://blog.youkuaiyun.com/miachen520/article/details/122390084)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *3* [[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains](https://blog.youkuaiyun.com/qq_43514711/article/details/122041247)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值