MySQL异常：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr...

最新推荐文章于 2023-01-30 09:53:48 发布
转载 最新推荐文章于 2023-01-30 09:53:48 发布 · 86 阅读 · 0 ·
CC 4.0 BY-SA版权
原文链接：https://my.oschina.net/u/2303177/blog/1627962

本文介绍了一个常见的MySQL错误：[Err]1055 - 'information_schema.PROFILING.SEQ'未出现在GROUP BY子句中，且与GROUP BY列不完全依赖。文章提供了修改my.ini文件中sql_mode参数的方法来解决这一问题。

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

2019独角兽企业重金招聘Python工程师标准>>> hot3.png

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; this is incompatible with sql_mode=only_full_group_by解决：在my.ini中加入如下代码：

[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

转载于:https://my.oschina.net/u/2303177/blog/1627962

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
[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
MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
qq_41399976的博客
05-31 240
解决这个问题有一个办法，就是修改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 255
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 246
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异常:[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 9442
在用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 Error 1055: Expression #1 of ORDER BY clause is not in GROUP BY ...
乐杨俊浅谈LAMP
01-30 499
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 2175
程序提示错误：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...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and ...解决办法
小婷
12-13 875
执行 sql语句 select version(), @@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); sql_mode是个很容易被忽视的变量，默认值是空值，在这种设置下是可以允许一些非法操作的，比如允许一些非法数据的插入。在生产环境必须将这个值设置为严格模式，所以开...
MYSQL异常Expression #1 of ORDER BY clause is not in GROUP BY clause 解决办法 MySQL
qq_40811171的博客
01-12 439
查看版本：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_SUBSTI...
MySQL是否支持expression_mysql5.7执行sql语句提示Expression #1 of ORDER BY clause is not in GROUP BY...
weixin_42506706的博客
01-19 107
mysql 新版本出现group by 语句不兼容问题[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 depende...
mysql5.7.25创建查询语句报[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause···的解决方案
weixin_42259631的博客
03-14 457
采用mysql5.7新版本的时候查询语句报“[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated ···”的错误时。采用如下解决方案： 1、找到mysql文件夹内的my.ini文件，修改sql_mode模式，如果没有这个配置，则添加： sql_mode...
解决[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQL
aaacccbbb1324的博客
07-18 861
错误： 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 ...
解决 Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY错误
热门推荐
Seven_0110的博客
01-08 1万+
数据库之前的版本是5.6，更换数据库到8.0之后，突然之前的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 i
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
yuguang的博客
11-19 629
### 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
mysql遇到的坑， Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
qq_43560721的博客
05-09 310
参考 https://blog.csdn.net/qq812457115/article/details/105768700
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
最新发布
09-02
- *1* [MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona...](https://download.csdn.net/download/weixin_38742656/13685329)[target="_blank" data-report...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值