[MySQL] GROUP BY 오류 해결 방법

java.sql.SQLException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '*******' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Query: SELECT * FROM `*******` GROUP BY `*******` ORDER BY `*******` Parameters: []

 

MySQL 터미널에 다음과 같은 명령어를 입력해주면 된다.

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));