Resolved: If you get ERROR: 1055
Take a look in the comments for the solution.
2 answers ( 2 marked as helpful)
1. Run the following query
set @@global.sql_mode := replace(@@global.sql_mode, 'ONLY_FULL_GROUP_BY', '');
2. Restart Workbench
3. Solution reference:
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
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