mysql 报错：1140 In aggregated query without GROUP BY, expression #

最新推荐文章于 2024-03-26 23:38:05 发布

码农の春天

最新推荐文章于 2024-03-26 23:38:05 发布

阅读量5.6k

点赞数 1

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/qq794554587/article/details/117219269

版权

mysql 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

1140 In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column ‘football.order.id’; this is incompatible with sql_mode=only_full_group_by
mysql5.7执行sql语句报错：In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column ‘football.order.id’; this is incompatible with sql_mode=only_full_group_by

找了好久找到可行的办法分享下

1.方法1，需要重启mysql服务

编辑/etc/my.cnf文件，加入如下参数，重启mysql

sql_mode = “STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER”

2.方法2，不需要重启mysql服务

可以看到模式为only_full_group_by

mysql>show variables like ‘%sql_mode’;

mysql> show session variables like ‘%sql_mode%’;

mysql> show global variables like ‘%sql_mode%’;

使当前会话失效

mysql> set global sql_mode=’ ';

mysql> set session sql_mode=’ ';