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"

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

Follow this topic

Omar Khaled

Last answered:

21 Dec 2022

Posted on:

20 Dec 2022

Error msg when applying the same code

in SQL / Stored Procedures with an Input Parameter

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

21 Dec 2022

Error msg when applying the same code

Submit an answer

related questions