mysql报错err1055

最新推荐文章于 2023-02-01 10:57:49 发布
最新推荐文章于 2023-02-01 10:57:49 发布
阅读量286 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_41694699/article/details/84867979
版权

mysql err 1055错误

解决思路：进入mysql 中查询sql_mode，拿到sql_mode的参数，然后把only_full_group_by取掉，复制剩余的参数，然后在my.cnf配置文件中粘贴进去，重启mysql服务

方法指导：
1.mysql -uroot -p’密码’
2.mysql> select @@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 |

  1. my.cnf配置文件一般都在 /etc/目录下面
  2. vim /ect/my.cnf ，把上面复制且去掉only_full_group_by的写入my.cnf文件中。
  3. service mysqld restart （redhat linux）重启mysql服务即可

sql_mode=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功能关闭了。至于only_full_group_by关闭好还是开着好。我在网上查了一个答案希望对你有帮助 mysql的only_full_group_by 模式是开启好还是关闭好？？

remember_me132
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
澎湖Java架构师的博客
06-07 1140
时间：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
mysql 报错Err] 1064，使用了mysql保留字
kfgauss的博客
04-30 262
insert into articles (title,desc,pic,url) values ('cc','dd','ee','ff') 遇到1064错误，而且没有提示任何原因，悲剧了。这个时代还要调试莫名其妙的error。 始终找不到错误。看了下面文章，才知道我用了错误的保留字desc。 mysql就不能提示一下嘛！ mysql 报错Err1064，使用了mysql保留字 https://blog.csdn.net/arrow_linux/article/details/45583299 执行插入语
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数据库报错 1055
Lione10的博客
03-13 1万+
MYSQL数据库报错 1055
MySQL 报错1055
琪丶琪的博客
08-19 1万+
一、问题描述 SELECT * FROM tbluser GROUP BY sex   当我以这条语句进行数据库查询的时候，报了个错： > 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ceb.tbluser.uid' which is no...
Mysql 报错1055
失眠因为想太多
03-21 1204
错误提示： [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 i
Mysql执行语句异常[Err] 1055
qq_35085640的博客
01-13 2166
Err1055，新版5.7以上执行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
vue使用mysql报错ERR_CONNECTION_REFUSED
最新发布
04-09
当使用Vue连接MySQL时，出现ERR_CONNECTION_REFUSED错误通常是由于以下几个原因导致的： 1. MySQL服务器未启动：请确保你的MySQL服务器已经正确启动。你可以通过检查MySQL服务状态或者尝试重新启动MySQL来解决此...
MySql插入数据成功但是报[Err] 1055错误的解决方案
12-16
在MySQL数据库操作中，我们有时会遇到插入数据时尽管数据被成功插入，但系统返回一个错误信息，如[Err] 1055。这个问题通常与MySQL的SQL模式设置有关，特别是当使用的是MySQL 5.7或更高版本时。在本篇文章中，我们将...
MySQL发生[Err] 1055的解决方案
weixin_48971493的博客
08-18 2137
MySQL发生[Err] 1055的解决方案 在使用group by时，如果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 dependent on colu
MySQL 报错：1055 版本问题引起SQL异常
u010637366的博客
11-03 233
一、问题描述 SELECT * FROM tbluser GROUP BY sex 1   当我以这条语句进行数据库查询的时候，报了个错： > 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ceb.tbluser.uid' which is not functionally dependent on columns in GROUP BY c
MySQL：报错 ERROR 1055 (42000)sql_mode=only_full_group_by
彭世瑜的博客
04-05 1626
报错 ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 原因： MySQL 5.
MySQL5.7--报错1055
syc1994的博客
09-26 1650
转自：https://blog.csdn.net/u283056051/article/details/52463948
MySQL报错1055解决办法
qq_40112624的博客
02-01 3095
最近在mysql 8.0.15版本中发现一个问题，在执行完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;
关于mysql5.7 [Err] 1055 group by
du拉松的博客
06-26 871
[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxx' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决MySql数据库报1055报错
热门推荐
纯洁的小魔鬼
01-28 3万+
使用mySql6.0时，由于group by引起的问题 mySql 5.7以上，sql_mode中的“only_full_group_by”是默认开启的，修改sql_mode参数即可 1.如果是windows系统，则把mySql中的my.ini中的sql_mode配置项修改则可,把only_full_group_by项删除,如果是Linux 则在my.cnf中 2.如果配置项中没有sq...
MySQL Error Code: 1055错误原因及其解决办法
qq_27753389的博客
03-19 1万+
1.问题描述 1055问题详细描述如下： Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘***’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
mysql5.7.23[Err] 1055的问题
weixin_38885605的博客
10-23 219
[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 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值