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)
2 answers ( 0 marked as helpful)
Hi Ioannis!
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.
Best,
Tsvetelin
where should i put this one ?
SET @@global.sql_mode := replace(@@global.sql_mode, 'ONLY_FULL_GROUP_BY', '');