Last answered:

13 Nov 2023

Posted on:

11 Nov 2023


why do i get an error in the query ?

1 answers ( 0 marked as helpful)
Posted on:

13 Nov 2023


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.

Submit an answer