MySQL error : sql_mode=only_full_group_by
Posted: Wed May 30, 2018 9:56 am
Hello,
I have this script where I'm used to doing a simple projection for a dynamic result but something goes wrong ; as i have this error :
1055 - Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mutuelle_bi.M.etat_bs' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
How may i modify my script, by the way, to solve this problem , given that I shouldn't modify any config file of my sql server . and i should only write scripts
Any Suggestions to fix this issue asap??
I have this script where I'm used to doing a simple projection for a dynamic result but something goes wrong ; as i have this error :
1055 - Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mutuelle_bi.M.etat_bs' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
How may i modify my script, by the way, to solve this problem , given that I shouldn't modify any config file of my sql server . and i should only write scripts
Any Suggestions to fix this issue asap??