Last answered:

13 Nov 2023

Posted on:

11 Nov 2023

0

why do i get an error in the query ?

1 answers ( 0 marked as helpful)
Instructor
Posted on:

13 Nov 2023

2

Hi Delih!
Thanks for reaching out.

Depending on your operating system and version of MySQL, you will be working with different SQL settings.

To make sure you can take some of the remaining lectures of the course without unnecessary interruption, we strongly advise you to execute the following query now.

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

Then, restart the Workbench in order to save the new settings.


Hope this helps.
Best,
Tsvetelin

Submit an answer