nonaggregated
-
[solved] ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db.table.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byDatabase/mysql 2020. 9. 23. 10:15
mysql에서 sql문에 'GROUP BY'를 사용하는데 아래와 같은 에러가 발생했다. ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db.table.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 쉽게 말하자면 sql_mode=only_full_group_by로 되어 있으면 잘못된 GROUP BY 사용을 제한한다. 엄격하게 용도에 맞게 사용 됐을때만 쿼리가 성공한다. 나의 경우 테이..