Error Code: 1140
I got this error and i tried to fix it with the code given:
set @@global.sql_mode := replace(@@global.sql_mode, 'ONLY_FULL_GROUP_BY', '');
and then to restart MySql service but it still didn't do anything. Is there another way to fix this?(using Windows)
Thanks for reaching out.
You have to run this query in the Workbench. Could you, please open a new tab and try the same code again? Then, restart the Workbench in order to save the new settings.
Hope this helps.