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

阿里云国内75折回扣微信号：monov8

阿里云国际，腾讯云国际，低至75折。AWS 93折免费开户实名账号代冲值优惠多多微信号：monov8 飞机：@monov6

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

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

原因：这是数据库的sql_mode设置的有问题。Mysql可以支持不同的SQL模式，不同的SQL模式会有不同的语法，执行不同的数据校验简查。

首先，可以先查看一下数据库现在的sql_mode的值，sql语句为：

select version(), @@sql_mode;

获取结果可能如下，不同的设置查询出来的有区别：

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

然后可以使用如下语句，去设置自己需要的sql_mode.

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

阿里云国内75折回扣微信号：monov8

阿里云国际，腾讯云国际，低至75折。AWS 93折免费开户实名账号代冲值优惠多多微信号：monov8 飞机：@monov6

返回列表

上一篇：误删数据怎么办？

下一篇：SpringBoot+Vue前后端分离项目排错思路

“SQL---Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column '” 的相关文章

Android 抓包相关 SSL相关1年前 (2023-02-02)

Windows下安装Nginx(详解)1年前 (2023-02-02)

AFNetworking整体框架简单整理1年前 (2023-02-02)

Codeforces 1630 E Making It Bipartite 题解 (Dilworth定理)1年前 (2023-02-02)

读函数式编程思维笔记01_演化的语言1年前 (2023-02-02)

【云服务器 ECS 实战】一文掌握负载均衡服务原理及配置方法1年前 (2023-02-02)

C/C++重点八股文1年前 (2023-02-02)

org.springframework.jdbc.BadSqlGrammarException: Error updating database1年前 (2023-02-02)

【web安全】——报错注入1年前 (2023-02-02)

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

“SQL---Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column '” 的相关文章

阿里云国际版