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
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 15, 2021 at 16:11 | comment | added | Richie Thomas | This worked for me. The MySQL docs state "This function is useful for GROUP BY queries when the ONLY_FULL_GROUP_BY SQL mode is enabled, for cases when MySQL rejects a query that you know is valid for reasons that MySQL cannot determine." So if your DB user doesn't have permissions to turn off 'ONLY_FULL_GROUP_BY', this is another option to consider. | |
| S Jul 9, 2020 at 8:48 | history | edited | user10216583 | CC BY-SA 4.0 |
deleted 9 characters in body
|
| S Jul 9, 2020 at 8:48 | history | suggested | Flynn Hou | CC BY-SA 4.0 |
refactored code block for better readability and fixed typos
|
| Jul 9, 2020 at 7:41 | review | Suggested edits | |||
| S Jul 9, 2020 at 8:48 | |||||
| Jan 31, 2020 at 14:20 | review | Late answers | |||
| Jan 31, 2020 at 14:23 | |||||
| Jan 31, 2020 at 14:01 | history | answered | siva.picky | CC BY-SA 4.0 |