joins Archives - Webner Blogs - eLearning, Salesforce, Web Development & More

MySQL: only_full_group_by issue on joins

Author - Ishpreet Kaur


#1055 – Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxx which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

After upgrading ubuntu 14.04 to 18.04 and MySQL 5.5 to Read more…