Hi i hava updated a mysql db to 5.7.xx and

Question

Hi i hava updated a mysql db to 5.7.xx and

some of my query get an error about sql_mode
"this is incompatible with sql_mode=only_full_group_by"
i have searched but almost all solution said to disable this mode but i want to resolve this problem by the the better way
for solve this problem i can not find the source of the problem
my question is how i can find source of this problem?

0

13.03.2019

1 ответов

14 просмотров

Carlos · Accepted Answer

Carlos

some of your queries probably have group by but not all fields selected are in the group by. This could lead to bugs so if you have mode only_full_group_by, it gives an error so you can fix your query

0

15.03.2019

Похожие чаты

Hi i hava updated a mysql db to 5.7.xx and

1 ответов

Похожие вопросы