Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't1.qysl' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

时间: 2023-05-31 11:04:47 浏览: 144

MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…

5星 · 资源好评率100%

[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_group_by 在navicat中使用mysql加索引或者删除索引时报了这个错。两种解决方在MySQL中，错误提示 "[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column…” 指的是在执行包含`GROUP BY`子句的查询时，你试图对未在`GROUP BY`子句中出现的列进行排序，且该列没有被聚合函数（如`SUM`, `AVG`, `COUNT`, `MAX`, `MIN`等）处理。这种行为与`sql_mode=only_full_group_by`设置不兼容，因为该模式要求所有出现在`ORDER BY`中的列必须在`GROUP BY`中或者被聚合函数所引用。 `sql_mode=only_full_group_by`是MySQL的一种严格模式，它确保了查询结果的可预测性和一致性，避免了因隐式聚合可能引发的不一致数据。在非严格模式下，MySQL可能会选择任意行的数据来代表每个组，而在严格模式下，这样做会被视为错误。当你在Navicat中尝试为MySQL表添加或删除索引时遇到这个错误，你可以采取以下两种解决方案： 1. **临时解决方法**： - 你可以检查当前的`SQL_MODE`设置： ```sql SELECT @@sql_mode; ``` - 接着，修改`SQL_MODE`以移除`ONLY_FULL_GROUP_BY`： ```sql SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); ``` 这样会临时关闭`only_full_group_by`模式，让你能够执行查询。但请注意，这只会对当前会话有效，重启数据库服务后会恢复原状。 2. **永久性解决方法**： - 找到MySQL配置文件`my.ini`，通常位于MySQL的安装目录下。如果你不确定路径，可以在Navicat中执行如下语句获取： ```sql SELECT @@datadir; ``` - 编辑`my.ini`文件，在`[mysqld]`段下，找到`sql_mode`设置，并将`ONLY_FULL_GROUP_BY`移除，例如： ``` [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服务，这样就永久改变了`sql_mode`设置。以上两种方法可以帮助你解决在Navicat中遇到的这个错误。然而，建议在生产环境中谨慎使用这种方法，因为`only_full_group_by`模式有助于防止潜在的错误和数据不一致。如果你的查询确实需要这样的排序，你应该考虑调整查询语句，将`ORDER BY`中的列包含在`GROUP BY`子句中，或者使用聚合函数来处理这些列。这不仅可以使你的代码更符合规范，也有助于提高查询的可读性和维护性。

Expression 是指表达某种意思或情感的方式或方式。这个词可以指口头或书面语言，也可以指面部表情、手势或其他非语言的方式来表达。在程序设计中，Expression 也指一种语言结构，它可以计算并返回一个值。

阅读全文

Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't1.qysl' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

相关推荐

mysql遇到Expression.docx

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't1.uid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 中文回答

Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lims.sr.status' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'docdb.a.TITLE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'user.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xkxgdb.b.addCuttype' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bookstore.book.图书编号' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'edds.p3.harness_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'longtanglongyin.longtanglongyin.CHECKTIME' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 什么错误？

java.sql.SQLSyntaxErrorException: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'a.grade' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'houmi.driver_assess_info. 日期' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nengyuanguanli.consumption_water.consumption' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'employee.employee.e_no' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'feiyuan.e.add_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.fruits.f_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dx2.a.admin_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

(1055, "Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sheji.sale.portion' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by")

1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yueke.a.uid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Time: 0.000000s

SQL_ERROR_INFO: "Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'er.score' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"

最新推荐

数据库基础测验20241113.doc

黑板风格计算机毕业答辩PPT模板下载

管理建模和仿真的文件

提升点阵式液晶显示屏效率技术

在SoC芯片的射频测试中，ATE设备通常如何执行系统级测试以保证芯片量产的质量和性能一致？

CodeSandbox实现ListView快速创建指南

"互动学习：行动中的多样性与论文攻读经历"

点阵式显示屏常见故障诊断方法

名词性从句包括哪些类别？它们各自有哪些引导词？请结合例句详细解释。

Node.js脚本实现WXR文件到Postgres数据库帖子导入