728x90 728x90 ONLY_FULL_GROUP_BY1 [MySQL; 마이에스큐엘] 오류 / 에러 / this is incompatible with sql_mode=only_full_group_by MySQL 5.7org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db.a.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by5.7 버전에 sql_mode라는 항목이 생겼는데 그 옵션 중 only_full_group.. 2024. 6. 14. 이전 1 다음 728x90 728x90
