mysql 8.0 关于group by 报错的问题
报错信息如下:
Cause: java.sql.SQLSyntaxErrorException: (conn=5097) Expression #1 of SELECT
list is not in GROUP BY clause and contains nonaggregated column 'XXXX.id' which is not functionally dependent on columns in G
ROUP BY clause; this is incompatible with sql_mode=only_full_group_by
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: (con
n=5097) Expression #1 of SELECT list is not in GROUP BY clause and contains nona
ggregated column 'XXXX.id' which is not functio
nally dependent on columns in GROUP BY clause; this is incompatible with sql_mod
e=only_full_group_by
解决办法:
etc里面的文件my.cnf 中添加 sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'
并重启mysql
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步