Error msg when applying the same code
when I apply the same code you applied in this lec I get this error msg "Error Code: 1140. In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'employees.e.first_name'; this is incompatible with sql_mode=only_full_group_by"
1 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Hi Anas!
Thanks for reaching out.
You need to run this code:
set @@global.sql_mode := replace(@@global.sql_mode, 'ONLY_FULL_GROUP_BY', '');
Then, you have to restart the Workbench in order to save the new settings.
Hope this helps.
Best,
Tsvetelin