MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause

最新推荐文章于 2023-01-30 09:53:48 发布
最新推荐文章于 2023-01-30 09:53:48 发布
阅读量210 收藏
点赞数
分类专栏： linux mysql 文章标签： mysql linux
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_41399976/article/details/90711996
版权
mysql 同时被 2 个专栏收录
13 篇文章 0 订阅
订阅专栏
linux
9 篇文章 0 订阅
订阅专栏

原文地址
原文地址：http://blog.sxpyw.com/article/index/36
解决这个问题有一个办法，就是修改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服务就可以了

吃井不忘挖水人
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
赵大白
07-11 564
完整错误### 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插入数据成功但是报[Err] 1055错误的解决方案
09-09
主要介绍了MySql插入数据成功但是报[Err] 1055错误的解决方案,需要的朋友可以参考下
mysql Error 1055: Expression #1 of ORDER BY clause is not in GROUP BY ...
乐杨俊浅谈LAMP
01-30 344
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
【sql： 踩坑】使用group by 运行sql 的时候 经常会报错
weixin_30443731的博客
08-09 922
报错日志： 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...
navivat输入sql语句 报错[Err] 1055 - Expression #1 of ORDER BY clause
tangerine_的博客
01-30 2570
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 ...
MySQL5.7 group by新特性报错1055的解决办法
12-16
MySQL 5.7引入了一项新的SQL模式，即`ONLY_FULL_GROUP_BY`，这导致了在升级后一些原本能够正常运行的SQL语句出现错误1055。这个错误主要出现在当你试图在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升级到5.7.22 遇到的第一个问题 “[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and
zclworld的博客
07-28 1万+
即上次升级了MySQL到5.7.22 后立马就开始导一些表开始体验下这个版本的数据库,结果刚建完表语句执行就报了一个错。具体信息如下“[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILI...
关于Mysql的[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 问题
KEY_cheung的博客
04-18 881
在今天导入数据库的时候出现了一个错误： [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...
MySQL异常:[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona...
一个正在努力的小菜鸡的记录
04-09 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 ...
navicat在执行sql语句命令时，报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and
weixin_34608610的博客
08-28 1万+
问题描述 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 dep...
mysql 5.7版本异常Expression #1 of ORDER BY clause is not in GROUP BY clause and contains 处理
热门推荐
尤宗旭的博客
09-29 2万+
今天在做按时间分组统计数据时，一段sql在数据库运行正常，但是在java代码中抛出了异常： sql语句： SELECT DATE_FORMAT( commitTime, '%H' ) AS gjtime , COUNT(1) AS gjsum FROM jenkins_data GROUP BY gjtime ORDER BY commitTime DESC java 抛出的异常信息： Expr...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 解决办法 MySQL
weixin_44997483的博客
07-26 861
解决办法： 第一句是查看，第二句才是解决办法。 执行sql 语句： select version(),@@sql_mode; SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
mysql数据库表新增text类型的字段报错——[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
qq_34266804的博客
05-07 476
未解决 [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 GROU...
mysql数据库版本问题Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
tyyking的博客
11-24 8103
一、查询mysql 相关mode 1、show variables like '%sql_mode%'命令 2、select version(), @@sql_mode 命令 没有结果 3、用sql查询 select @@global.sql_mode 有结果了 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO...
解决mysql报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
b_bunana的博客
04-24 1880
这是数据库报错 [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 G...
数据库Mysql报错： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and
法国锄头雨
07-05 738
解决方法如下 数据库执行： select version(), @@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
[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、付费专栏及课程。

余额充值