Last answered:

11 Nov 2024

Posted on:

11 Nov 2024

0

Resolved: If you get ERROR: 1055

Take a look in the comments for the solution.
2 answers ( 2 marked as helpful)
Posted on:

11 Nov 2024

0

1. Run the following query


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


2. Restart Workbench


3. Solution reference:


https://365datascience.com/q/8f04051ff8

Instructor
Posted on:

11 Nov 2024

0
Hi Dimiter!
Thanks for reaching out.
Thank you for sharing an explanation on setting the SQL mode in Workbench.
Good luck with taking the rest of the coruse and please feel free to post another question should you encounter any difficulties. Thank you.
Best,
Martin

Submit an answer