A super detailed tutorial: springboot integrates mybatis plus>>> 
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mer_cash.m.head_portrait' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byMySQL 5.7.5 and above functions rely on the detection function. If only is enabled_ FULL_ GROUP_ By SQL mode (by default), MySQL will reject queries that select lists, having conditions, or order by lists, refer to non collection columns that are neither named nor functionally dependent on them in the group by clause
The best solution is to optimize SQL: use any_ The value function returns any value
You can also modify the configuration of the database to remove only in the configuration file of the database_ FULL_ GROUP_ By this value
Modify my.cnf configuration. If there is no configuration item, add one as follows
|
|
Similar Posts:
- [Solved] SELECT list is not in GROUP BY clause and contains nonaggregated
- [Solved] MySQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
- [Solved] MYSQL Command gruop by Error: this is incompatible with sql_mode=only_full_group_by
- SELECT list is not in GROUP BY clause and contains nonaggregated
- [Solved] Laravel Groupby error: laravel which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
- Mysql Error: 1140 – In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column ‘a.store’; this is incompatible with sql_mode=only_full_group_by
- [Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
- [Solved] MYSQL8 group by Error: Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY
- Laravel uses group by to report errors [How to Solve]
- Laravel Syntax error or access violation: 1055 ‘***’ isn’t in GROUP BY