解决MySQL Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colum

静&慢&远

于 2023-04-25 11:43:45 发布

阅读量114

点赞数

分类专栏： Mysql 文章标签： mysql 数据库 docker

本文链接：https://blog.csdn.net/weixin_42014858/article/details/130361517

版权

Mysql 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

修改mysql配置文件

在这里插入图片描述
我的版本是5.7用docker安装的

解决方法是在配置文件加上这段话

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

在这里插入图片描述

如果没有vi,要安装下vi

yum install vi

你也可以用copy的方式修改

mysql是镜像名称
容器到宿主机
docker cp mysql:/etc/my.cnf /root/my.cnf
 
宿主机到容器
docker cp /root/my.cnf mysql:/etc/my.cnf

然后重启

docker restart mysql

优惠劵

静&慢&远

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
解决MySQL Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colum

我的版本是5.7用docker安装的。
复制链接

扫一扫

专栏目录

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 ...

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

西格玛猫

12-27

5331

问题：[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............

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains n

m0_37635053的博客

07-22

4432

[Err] 1055 - ORDER BY子句的表达式#1不在GROUP BY子句中，并且包含非聚合列’information_schema.PROFILING '。SEQ’在功能上不依赖于GROUP BY子句中的列;这与sql_mode=only_full_group_by不兼容问题出现的原因： MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQ...

Docker MySql 主从配置

weixin_34221773的博客

08-08

Master配置 mkdir -pv /data/mysql/data mkdir -pv /data/mysql/16 复制代码vi /data/mysql/16/16.cnf [mysqld] log-bin=mysql-bin server-id=16 复制代码 docker create --name MySqlMaster -v /data/mysql/data/mysql16:/v...

MySQL - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

牧码的博客

05-18

925

--数据库中插入数据或执行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 columns in GROUP BY clause; this is incompatible with sql.

解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated

12-15

如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测...

mysql遇到Expression.docx

03-05

mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题

解决MySQL 5.7.9版本sql_mode=only_full_group_by问题

12-16

用到GROUP BY 语句查询时com.MySQL.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘col_user_6.a.START_TIME’ ...

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column...

weixin_42121675的博客

06-29

9519

报错内容 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'xxx.table.column' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 问题分析：出现的问题是由

MySQL报错1055解决办法：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains

野马菲比的博客

12-20

4万+

【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

mysql5.7 group报错ERROR 1055 (42000): Expression #1

Marhal的博客

03-27

665

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错误Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colum

Janet_5的博客

07-24

2002

程序提示错误：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 原因：数据库sq...

mysql sql_mode小分享

王鹏的专栏

07-17

698

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

mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题

热门推荐

N-SOKACH的博客

09-19

18万+

报错如下： Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sss.month_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompat

mysql 1130错误和1055 - Expression #1 of ORDER BY clause is not in GROUP BY

u010785091的博客

12-27

3111

解决这问题就挺简单的，就是没有权限。 1 登陆mysql mysql -uroot -p 2修改权限GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'121.25.33.55' IDENTIFIED BY 'password' WITH GRANT OPTION;下面这个是解决5.7版本以上的mysql ，运行低版本mysql时候的错误select versi...

关于mysql 8.0版本运行sql出现[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and ...

呆_呆的博客

07-09

4510

最近mysql数据库版本又5.x.xx换成了mysql8.0.20,执行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 cl...

mysql执行sql语句提示Expression #1 of ORDER BY clause is not in GROUP BY

老刀

06-20

8885

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"

测试喵~

11-15

3万+

升级之后马上体验了一下，执行“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.PROF...

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

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

非常没帮助
没帮助
一般
有帮助
非常有帮助

提交