Mysql #1055 — 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 Hatası Çözümü

Image for post
Image for post
#1055 — 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
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Written by

Bilgisayar Müh. Digidea Dijital Hizmetler Ltd. Şti. #NetCore #Angular #Vue #Codeigniter

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store