MySQ：mysql-5.7.30-linux-glibc2.12-x86_64
生未知异常.
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #21 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sxdb.m.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决方法：
vi /etc/my.cnf
[mysqld]
...
sql_mode =STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
[mysql]
...
sql_mode =STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
重启MySQL服务。
- only_full_group_by incompatible sql_mode group thisonly_full_group_by incompatible sql_mode group group only_full_group_by incompatible sql_mode only_full_group_by sql_mode mysql group only_full_group_by sql_mode版本 办法 only_full_group_by aggregated函数sql_mode only_full_group_by nonaggregated incompatible only_full_group_by sql_mode解决方案 版本 only_full_group_by functionally incompatible only_full_group_by only_full_group_by mysql group only