MySQL中的报错[Err] 1055 -- Expression #1 of ORDER BY

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

原因是因为配置文件中加载数据的时候排序出了问题。。详细问题没搞懂

加两行代码可以解决

1.当执行select version(), @@sql_mode; 的时候可以看到

2.把ONLY_FULL_GROUP_BY设置为空就可以解决问题。。

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

奇怪的是在dom界面下不会报错

 

写了 挺久了一直在文档中，之前在哪个网站搜到的答案忘记了

youshang520i
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
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 ...
MySQL报错1055解决办法
Pxy112233的博客
06-30 2394
MySQL报错1055翻译为“无法给包含一个非聚合的列进行分组，这个功能不再依赖分组，且与新的规则不兼容sql_mode=only_full_group_by”④建议以管理员方式打开记事本，在记事本中文件--打开--输入路径--右下角选择全部文件，选中my.ini这个配置文件，打开。⑤Ctrl+F快捷键查找sql_mode，如果没有，就查找sql或者mode一个一个找，可能被换行书写了，注意眼睛仔细找。⑥删除only_full_group_by，保存。发现里面有only_full_group_by。
MySQL报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
热门推荐
野马菲比的博客
12-20 3万+
【mysql报错1055 报错解决办法】[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 sq
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘
weixin_45773788的博客
06-25 2425
执行带group by的SQL语句出现如下错误：ERROR1055：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'db.tb_list.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_g
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
baidu_36882394的博客
04-24 6000
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c 异常：在执行一段SQL时出现以下问题 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and con...
Mysql问题：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
afei8080的专栏
03-09 1561
MySql only_full_group_by规则
MySql插入数据成功但是报[Err] 1055错误的解决方案
09-09
主要介绍了MySql插入数据成功但是报[Err] 1055错误的解决方案,需要的朋友可以参考下
通信与网络中的交换机err-disable故障解决方法
11-26
导致交换机接口出现err-disable的几个常见原因: 引用　1. EtherChannel misconfiguration　2. Duplex mismatch　3. BPDU port guard　4. UDLD　5. Link-flap error　6. Loopback error　7. Port security violation...
Linux服务器系统性能参数配置不当引起的网站访问报错ERR-CONNECTION-TIMED-OUT 200解决方法
最新发布
08-11
NAT网络环境下 针对性能参数的配置要特别注意，因为很有可能导致我们部署的网站不稳定，而且前后端没有错误日志，只能通过工具抓包去排查发现问题，这个文件告诉你如何去调整相关的参数来避免ERR_CONNECTION_TIMED_...
libcom_err-devel-1.42.9-19.el7.i686.rpm
07-06
libcom_err-devel-1.42.9-19.el7.i686.rpm
MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains问题
XING的博客
05-16 273
会报下面的错误，Navicat版本较低造成的，不影响结果的显示，查询结果也是正确的。更新的Navicat版本，或者下载免费试用的最新版本，就不会有个错误提示了。使用Navicat连接MySQL数据库进行查询的时候，如果。MySQL的配置文件里增加。
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 解决办法 MySQL
西格玛猫
12-27 5316
问题：[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 ...
解决MySQL报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘informat
HaHa_Sir的博客
05-29 2万+
解决MySQL报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat一、问题描述新安装的MySQL5.7.22 或 8.0.11，在 Navicat 上执行删除操作时，遇到报错：[Err] 1055 - Expre............
MySQL 错误代码:1055 解决方案（推荐！！）
zhuzicc的博客
05-08 2万+
MySQL 错误代码:1055 解决办法一、 问题描述1. MySQL版本：8.0.112.ONLY_FULL_GROUP_BY-SQL示例二、解决办法1.方法一2.方法二 一、 问题描述 1. MySQL版本：8.0.11 在查询时使用group by语句，出现错误代码：1055 SELECT t1.id, t1.`room_name`, t2.`room_id`, t2....
mysql5.7 group报错ERROR 1055 (42000): Expression #1
Marhal的博客
03-27 658
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...
mysql报错ORDER BY clause is not in SELECT list, references column ‘‘which is not in SELECT list解决方案
cucgyfjklx的博客
07-07 1万+
mysql报错Expression #1 of ORDER BY clause is not in SELECT list, references column 'fusion.m.create_time' which is not in SELECT list; this is incompatible with DISTINCT解决方案
Mysql this is incompatible with sql_mode=only_full_group_by
weixin_44422857的博客
08-12 452
MySQL的sql_mode合理设置 sql_mode是个很容易被忽视的变量,默认值是空值,在这种设置下是可以允许一些非法操作的,比如允许一些非法数据的插入。在生产环境必须将这个值设置为严格模式,所以开发、测试环境的数据库也必须要设置,这样在开发测试阶段就可以发现问题. sql model 常用来解决下面几类问题 (1) 通过设置sql mode, 可以完成不同严格程度的数据校验，有效地保障数据...
MYSQL---Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
JacksonKing的专栏
01-19 1042
--数据库中插入数据或执行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...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值