Timeline for SELECT list is not in GROUP BY clause and contains nonaggregated column .... incompatible with sql_mode=only_full_group_by
Current License: CC BY-SA 4.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 8, 2022 at 15:27 | comment | added | Martin_Lakes | I have to use it like this for it to work: SET @@sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); | |
| Dec 28, 2021 at 13:36 | history | answered | CodingBee | CC BY-SA 4.0 |