mysql5.7提示[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonag

最新推荐文章于 2023-07-09 11:16:05 发布
最新推荐文章于 2023-07-09 11:16:05 发布
阅读量2.1k 收藏
点赞数
分类专栏： mysql 文章标签： mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/shaofei_huai/article/details/119056718
版权

        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可通过如下两种方式解决

        方法一：客户端修改sql_mode，修改后再打开的客户端不会出现此问题，但重启数据库sql_mode失效。

SHOW GLOBAL VARIABLES LIKE  "sql_mode"    -- 查看是否包含ONLY_FULL_GROUP_BY

SET GLOBAL  sql_mode =(SELECT REPLACE ( @@sql_mode,'ONLY_FULL_GROUP_BY','') FROM DUAL) -- 
 包含ONLY_FULL_GROUP_BY对其进行替换。

        方法二：修改my.cnf配置文件，永久解决此问题。

SHOW GLOBAL VARIABLES LIKE  "sql_mode"    -- 查看是否包含ONLY_FULL_GROUP_BY

手动替换ONLY_FULL_GROUP_BY
修改my.cnf文件 在[mysqld] 下增加sql_mode='上一步替换过的值'

        关于sql_mode详细参数可参考https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
     

shaofei_huai
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains问题
XING的博客
05-19 217
会报下面的错误，Navicat版本较低造成的，不影响结果的显示，查询结果也是正确的。更新的Navicat版本，或者下载免费试用的最新版本，就不会有个错误提示了。使用Navicat连接MySQL数据库进行查询的时候，如果。MySQL的配置文件里增加。
MySQL5.7 group by新特性报错1055的解决办法
12-16
MySQL 5.7引入了一项新的SQL模式，即`ONLY_FULL_GROUP_BY`，这导致了在升级后一些原本能够正常运行的SQL语句出现错误1055。这个错误主要出现在当你试图在GROUP BY子句中使用未聚合的列时，而这些列并未在GROUP BY或...
MySql插入数据成功但是报[Err] 1055错误的解决方案
09-09
主要介绍了MySql插入数据成功但是报[Err] 1055错误的解决方案,需要的朋友可以参考下
MySql错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
fxjzzyo的博客
07-09 2569
更新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; 本文章记录了该问题的解决过程。
mysql5.7 group报错ERROR 1055 (42000): Expression #1
Marhal的博客
03-27 682
ubuntu16.04 apache2.4 php7.0 mysql5.7 $order_goods=db('order_goods')->where('orderid','in',$_orderid_arr)->group('orderid')->having('id>0')->select(); echo db('order_goods')->getL...
报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregat
邵奈一的博客
12-30 1773
在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 wi
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
热门推荐
小菜鸟入门
08-27 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 ...
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona关于数据库insert into报错
qq_38359034的博客
11-30 2389
先执行select @@sql_mode查询出来的值复制出来，删除 部分，将set @@sql_mode=删除ONLY后的字符串
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中错误：1093-You can’t specify target table for update in FROM clause的解决方法
12-16
在MySQL中，错误1093 - "You can't specify target table for update in FROM clause" 是一个常见的问题，它发生在尝试在`UPDATE`语句的`FROM`子句中直接引用要更新的同一张表时。这个错误表示MySQL不支持在`UPDATE`...
Mysql问题：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
afei8080的专栏
03-09 1584
MySql only_full_group_by规则
MYSQL---Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
JacksonKing的专栏
01-19 1062
--数据库中插入数据或执行sql语句时一直报下面这个错误： 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 c...
【sql： 踩坑】使用group by 运行sql 的时候 经常会报错
weixin_30443731的博客
08-09 913
报错日志： Expression #2 of SELECT list is not in GROUP BY clause and containsnonaggregated column ‘sss.month_id’ which is not functionallydependent on columns in GROUP BY clause; this is incompati...
MySQL5.7.27报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains no...
09-06 6830
mysql5.7.27在运行更新语句时出现如下情况，mysql5.6之前没有这种情况出现。 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which...
mysql sql_mode小分享
王鹏的专栏
07-17 706
mysql sql_mode参数小节 mysql，sql实例SELECT charges,mealstime,name,sd_meal.id,fixedcharges,balancecharges,payablecharges FROM sd_meal,lcmemdata,sd_conservation WHERE sd_meal.childuid=lcmemdata.childi
数据库报错： Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
weixin_46945048的博客
07-07 1295
数据库操作出错 操作语句： TRUNCATE contract_ele; 错误信息： [SQL]TRUNCATE contract_ele; 受影响的行: 0 时间: 0.156s [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 functiona
[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、付费专栏及课程。

余额充值