only_full_group_by1 [MySQL] expression #1 of SELECT list contains nonaggregated column ### Cause: java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column '{{내컬럼}}'; this is incompatible with sql_mode=only_full_group_by ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column '{{내컬럼}}'; this is.. 2020. 7. 16. 이전 1 다음