我的MySQL版本是8.0.28;
1、通过下方SQL语句查询:
SELECT @@sql_mode;
2、查看是否存在 `ONLY_FULL_GROUP_BY`字段?
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
3、如果存在上方字段,使用下方SQL语句:
set sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
4、再次查询查看是否还有`ONLY_FULL_GROUP_BY`字段?
STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
5、之后再执行分组操作便不会报错了