windows下 mysql报错 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and

最新推荐文章于 2021-06-01 14:45:40 发布
最新推荐文章于 2021-06-01 14:45:40 发布
阅读量278 收藏 1
点赞数
分类专栏： # Mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zx1323/article/details/102731296
版权

mysql插入数据时报错

基本上网上一搜全是需要修改sql_mode

 

SELECT @@GLOBAL.sql_mode;

SELECT @@SESSION.sql_mode;


set sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';


set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

然而 我使用的是windows 发现重启mysql后就重置了, 改配置文件也是无效的

 

 最终找到

https://stackoverflow.com/questions/23921117/disable-only-full-group-by/23921234

用命令行启动 带上参数  --sql-mode="具体的模式"

如:

mysqld.exe --sql-mode=""

 

 

zx1323
关注
专栏目录
解决[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
weixin_43520450的博客
03-15 3170
[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 1146
时间：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
[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
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
yemuyouhan的博客
12-10 6879
在用Navicat写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 depend...
mysql创建函数1055错误_mysql [err] 1055错误解决
weixin_39577289的博客
01-21 281
前言在使用mysql是在navicat中查询一条简单语句使用了select * from table虽然查询成功了,但是报了[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SE...
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 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...
Navicat 执行sql语句报错1055---of ORDER BY clause is not in GROUP BY
weixin_44529753的博客
04-06 1032
简单的说一下， 遇到的问题是：当我执行一条insert语句会报错，但是不影响，但是当我执行多条语句的时候，就无法执行了。 这是我的报错信息 这是在MySQL5.7之后，sql_mode中默认存在ONLY_FULL_GROUP_BY，SQL语句未通过ONLY_FULL_GROUP_BY语义检查所以报错。 更详细请看：MySQL1055 GROUP 第一种方法： 在 Navicat中点击查询，新...
报错：[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
解决MySQL报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat...
weixin_30336061的博客
02-19 712
解决MySQL报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat 转自：https://blog.csdn.net/HaHa_Sir/article/details/80503601 2018年05月29日 23:10:52HaHa_Sir...
MYSQL常见问题解决-[Err] 1055 - Expression #1 of ORDER BY clause
growing1224的博客
05-18 995
使用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_SUBSTITUTI
MySQL(6):Mysql5.7数据库插入时报错[Err] 1055 clause is not in GROUP BY clause
fen_fen的专栏
06-01 124
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c 参考:
MySQL学习14_mysql执行sql语句提示Expression #1 of ORDER BY clause is not in GROUP BY
wang_zhenwei的博客
04-22 574
mysql 新版本出现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 depen...
MySQL升级到5.7.16 遇到的第一个问题“[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and“
沮丧的南瓜
05-23 182
升级之后马上体验了一下，执行“UPDATE user_course SET userid = 200 WHERE id = 28;”，结果报 [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 colum
[Err] 1055 - Expression #1 of ORDER BY解决办法 MySQL
shi860715的博客
11-19 551
这个问题一般Navicat 版本低 方法一：通过命令来解决 select version(), @@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); 方法二： 可以使用sqlyong工具，不存在这样的问题
Mysql报错：1 of ORDER BY clause is not in GROUP BY clause....
qq_38286002的博客
06-28 546
Navicat执行sql语句会报如下错误： 原因：是在mysql中高版本的Mysql中，sql_mode默认自带了ONLY_FULL_GROUP_BY模式； 解决方案： 1.打开mysql配置文件：my.cnf # vim /etc/my.cnf 在最后一行添加如下配置： sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERR...
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contai
weixin_30603633的博客
12-31 677
之前一直使用的mysql5，突然换成8之后，有许多地方不一样，今天就碰到一个。 在使用sql语句创建表时，报错： 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ'...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值