Mengatasi Error query GROUP BY di Mysql 5.7

Error seperti ini terjadi karena terdapat sql_mode only_full_group_by di settingan mysql. Contoh error yang tampil ketika mengeksekusi query group by. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘support_desk.mod_users_groups.group_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Sedangkan cara simple … “Mengatasi Error query GROUP BY di Mysql 5.7”

Read More