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=’ ‘;复制代码 ———————————————— 版权声明：本文为CSDN博主「码农の春天」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。 原文链接：https://blog.csdn.net/qq794554587/article/details/117219269 |
