MYSQL常见问题解决-[Err] 1055 - Expression #1 of ORDER BY clause

最新推荐文章于 2024-07-29 15:18:54 发布
最新推荐文章于 2024-07-29 15:18:54 发布
阅读量995 收藏 1
点赞数 1
分类专栏： # Mysql 文章标签： 数据库 mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/growing1224/article/details/106186496
版权

使用Navicat for MySQL连接MYSQL5.7时，创建表语句执行后，表虽然创建成功了，但是会报错，错误信息如下:

  • 查看MYSQL的sql_mode，发现有ONLY_FULL_GROUP_BY参数

  • 在myql配置文件中(my.ini文件)重新对sql_mode 赋值(永久设置)
    sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

  • 对当前连接生效

       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 nonaggregated
weixin_43520450的博客
03-15 3168
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
MySQL报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
澎湖Java架构师的博客
06-07 1144
时间：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] 1055 - Expression #1 of ORDER BY clause
HY0101的博客
04-02 828
出现问题： [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_f
【已解决】数据加工错误开窗--You cannot nest a window function in the specification of window ‘＜unnamed windo原因）
最新发布
九霄云客的博客
07-29 198
在数据加工过程中，如果在定义窗口函数时,是不能嵌套其他的窗口函数的，即窗口函数的参数不能被开过窗。如果非要嵌套使用开窗，只能多做一层加工，用子查询替换原始查询，然后再开窗，这相当于在子查询里开窗，只开过一次，而非嵌套开窗。 解决方案：1、将原始查询先加工得出最大日期； 2、用加工过的原始查询即子查询来代替原先的原始查询，在这样的基础上开窗，就避免了嵌套开窗报错的情况。
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
yeying_bing的博客
12-24 3114
[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_gro
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
若初容若
05-23 1664
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 inc
MySQL中的报错[Err] 1055 -- Expression #1 of ORDER BY
youshang520i
11-13 1206
原因是因为配置文件中加载数据的时候排序出了问题。。详细问题没搞懂 加两行代码可以解决 1.当执行select version(), @@sql_mode; 的时候可以看到 2.把ONLY_FULL_GROUP_BY设置为空就可以解决问题。。 SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); 奇...
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`子句中...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 解决办法 MySQL
10-10
否则，将会出现 "Expression #1 of ORDER BY clause is not in GROUP BY clause" 的错误。 解决办法之一是，将非聚合列添加到 GROUP BY 子句中。例如，假设你有一个名为 "table_name" 的表，其中包含列 "column1" ...
MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains
StrongTeacher的博客
11-17 639
使用Navicat连接数据库进行查询的时候，如果Navicat版本较低，MySQL数据库又5.7以上的版本，会报下面的错误，Navicat版本较低造成的，不影响结果的显示，查询结果也是正确的。 [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 funct
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
cjg2522的博客
12-23 203
ORDER BY clause is not in GROUP BY
mysql运行时报[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
海边凝望的博客
03-23 185
2、在mysqld后面加入一句：sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION。在mysql安装目录下找到my.ini文件，右击打开。1、需要修改my.ini文件。3.重启mysql服务器。
mysql-1055错误 MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
LoweMuo_洛漠
09-18 7031
mysql-1055错误 MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 想着给数据库里插入一条测试数据，居然报错了可奇葩的是报错了数据居然还插入进去了。 看了一下原来是因为mysql版本的问题。。 在MySQL5.7之后，sql_mode中默认有一条ONLY_FULL_GROUP_BY，S...
报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregat
邵奈一的博客
12-30 1805
在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 的问题 MySQL
qq_43211632的博客
03-27 2425
完美的解决方案是： 第一步：show variables like “sql_mode”; 第二步：set sql_mode=’’; 第三步：set sql_mode=‘NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES’;
docker 下 mysql 5.7 修改sql_mode [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY ..
koloumi的博客
09-14 1523
[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.
小妖的黑色城堡的博客
03-30 411
因为要按照各Jenkins+sonar的自动化部署加监测的环境，之前使用的mysql5.1不支持sonar，所以重新装了mysql5.7版本，但是安装之后项目报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated.上网查了下找到解决办法，分享一下：htt...
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated..
M.Blog
03-05 2444
最近在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 function...
问题：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregate
qq_38448815的博客
03-14 264
问题：[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 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值