MySql [Err] 1055 - Expression

最新推荐文章于 2024-10-11 07:30:00 发布
最新推荐文章于 2024-10-11 07:30:00 发布
阅读量180 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： MySQL
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_37996243/article/details/102509618
本文详细介绍了在使用MySQL执行SQL语句时遇到的only_full_group_by错误，并提供了具体的解决方案。通过修改my.ini文件中的sql_mode参数并重启服务，可以有效解决因非聚合字段在GROUP BY子句外引起的报错。

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

mysql执行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 with sql_mode=only_full_group_by

解决方式：

在my.ini文件中增加sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'，重启服务。

可以用select @@sql_mode;语句查看sql_mode

MySQL 报错[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregat
qq_59241934的博客
04-28 4631
报错信息： Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tp_music.singer.name’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group...
解决Mysql：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
qq_42926722的博客
10-25 5347
解决Mysql：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
12-14
[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 在navicat中使用mysql加索引或者删除索引时报了这个错。 两种解决方
MySQL-[Err] 1055 - Expression #1
我本善良编程专栏
05-12 2778
标题试验环境 操作系统：windows 2012 数据库系统： MySQL 5.7.22 问题重现 1）安装好数据库后尝试创建表，报错： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFI...
MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains问题
最新发布
XING的博客
10-11 1296
会报下面的错误，Navicat版本较低造成的，不影响结果的显示，查询结果也是正确的。更新的Navicat版本，或者下载免费试用的最新版本，就不会有个错误提示了。使用Navicat连接MySQL数据库进行查询的时候，如果。MySQL的配置文件里增加。
[Err] 1055 - Expression this is incompatible with sql_mode=only_full_group_by
m0_57855994的博客
08-07 288
[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
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
处理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
奔跑的兔子
03-10 1934
[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 nonaggregated
热门推荐
innerpeaceScorpio的博客
07-06 2万+
   &a
Mysql执行语句异常[Err] 1055
A_4201314的博客
06-28 370
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，去掉ONLY_FULL_GROUP_BY，网上很多方法都是用sql修改这个值，mysql重启后失效，要永久修改则必须修改my.cnf文件才凑效。1在mysql查询脚本查看sql_mode内容。3.重启Mysql服务。
[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated colum...
weixin_35753291的博客
01-05 507
[Err] 1055 - Expression #1055 异常是一种 MySQL 数据库错误。这通常表明在执行查询时发生了一个错误，并且查询无法完成。这可能是由于查询语法错误、数据库对象名称错误或其他因素导致的。为了解决这个问题，您可以尝试检查查询语法、确保您使用的数据库对象名称是正确的，并且确保您有足够的权限来执行此查询。 ...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQL
Pannahouse的博客
02-14 2288
问题：[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 ...
navicat在sql语句时，报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contai
那年的博客
11-23 876
问题：navicat在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 with s
MySql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
fxjzzyo的博客
07-09 3302
更新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; 本文章记录了该问题的解决过程。
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 解决办法 MySQL
西格玛猫
12-27 5466
问题：[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 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、付费专栏及课程。

余额充值