Last answered:

29 Aug 2023

Posted on:

01 Jun 2023

0

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)
Instructor
Posted on:

05 Jun 2023

0

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

Posted on:

29 Aug 2023

0

where should i put this one ?

SET @@global.sql_mode := replace(@@global.sql_mode, 'ONLY_FULL_GROUP_BY', '');

Submit an answer