1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘apimonitor.t.cr...

最新推荐文章于 2024-03-25 14:21:37 发布

转载最新推荐文章于 2024-03-25 14:21:37 发布 · 275 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

原文链接：https://www.91mszl.com/zhangwuji/article/details/1297

收录于

当前文章被以下社区和专栏收录：

本文介绍了如何在Windows环境下，通过修改MySQL配置文件my.ini并设置sql_mode参数为'ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'来解决因ENGINE=MyISAM导致的查询错误。重启MySQL后，问题得到解决。

修改数据表 ENGINE = MyISAM 后，执行任何查询语句都会报告该错误，在试了一些博客的方法后解决；如下：
sql版本

window mysql 8.0

修改mysql配置文件 my.ini，在最后一行添加

sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

再重启mysql即可。

标签

#mysql

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

小丙乙

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

解决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 sql_mode小分享

王鹏的专栏

07-17

937

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

参与评论您还未登录，请先登录后发表或查看评论

解决[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated

weixin_43520450的博客

03-15

3986

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

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

Marhal的博客

03-27

848

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

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

weixin_45773788的博客

06-25

2725

执行带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

mysql报错：ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

热门推荐

总结经验，与君共勉

12-05

1万+

在mysql5.7之后的版本运行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 de...

MySQL操作报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colu

蛤？

03-25

2113

Mysql数据库操作报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat。这个问题主要是由于sql_mode引起，所以先查看sql_mode 然后修改即可，主要是去除only_full_group_by。说明：此方法可以解决大部分mysql8出现的上述报错，配置之后若不生效或启动错误需删除以上配置并需求新的解决方案。

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

weixin_42121675的博客

06-29

1万+

报错内容 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错误：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr

fxjzzyo的博客

07-09

3452

更新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; 本文章记录了该问题的解决过程。

解决MySQL报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat

liu_shi_jun的专栏

10-22

7885

一、问题描述新安装的MySQL5.7.22 或 8.0.11，在 Navicat 上执行任一查询操作时，遇到报错： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ ...

mysql - windows下my.ini和linux下my.cnf简单配置

qq_25598453的博客

03-26

4854

[mysql] # 设置mysql客户端默认字符集 default-character-set=utf8 [mysqld] #设置3307端口 port = 3307 # 设置mysql的安装目录 basedir=G:\a_workIndex\mysql\mysql-5.7.24 # 设置mysql数据库的数据的存放目录 datadir=G:\a_workIndex\mysql\mysql-5...

ORDER BY clause is not in GROUP BY clause

weixin_42210195的博客

05-28

1870

一、报错：[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 - Expression #1 of ORDER BY clause is not in GROUP...

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

Janet_5的博客

07-24

2292

程序提示错误：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 5.7 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colu...

weixin_30687587的博客

09-09

923

使用mysql在执行一条插入语句时 insert into channel(channel_id, channel_no,channel_name) values(1, '1000', "hhh"); 报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated...

Mysql ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 问题的处理

weixin_34403693的博客

01-25

1060

2019独角兽企业重金招聘Python工程师标准>>> ...

解决MySQL5.7报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column...

weixin_42465125的博客

03-10

5711

解决MySQL5.7报错：[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，执行操作时，遇到报错： [Err] 1055 - Expression ...

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

05-18

1231

--数据库中插入数据或执行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.

MySQL配置文件my.ini的一般设置

学无止境

08-26

1万+

[mysqld] # 设置3306端口 port=3306 # 设置mysql的安装目录 basedir=D:\Software Package\mysql-8.0.12-winx64\mysql-8.0.12-winx64\ # 设置mysql数据库的数据的存放目录 datadir=D:\database\MySQL\Data # 允许最大连接数 max_connections=200 # 允...

Mysql问题：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause

afei8080的专栏

03-09

1884

MySql only_full_group_by规则