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
19 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 24, 2023 at 9:37 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
added 227 characters in body
|
| Feb 25, 2023 at 17:44 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
added 22 characters in body
|
| Sep 11, 2022 at 14:48 | comment | added | John Smith | yes, it could be. Thanks. | |
| Sep 11, 2022 at 14:33 | comment | added | Ahmad Mobaraki | @JohnSmith did not quite get what you mean, but I think for your specific table data you get only one record, so if you had more (different) data, you would get multiple results? I think Mysql does not care (predict) if you will have one or many results, it's the query and the fields that comes after SELECT that are ambiguous. | |
| Sep 11, 2022 at 14:18 | comment | added | John Smith | and if there are no ambiguous fields, because after a "LEFT JOIN" only one record goes? Then why I get this? | |
| Aug 15, 2022 at 11:36 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
deleted 13 characters in body
|
| May 24, 2022 at 18:28 | comment | added | Synkronice | Thanks so much to explain this issue. Now I understand better what is wrong in my query! | |
| Nov 18, 2021 at 5:16 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
added 4 characters in body
|
| Jul 17, 2021 at 5:24 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
deleted 25 characters in body
|
| Jul 4, 2021 at 14:57 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
added 1 character in body
|
| Jul 3, 2021 at 4:53 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
deleted 4 characters in body
|
| Jun 17, 2021 at 5:45 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
added 109 characters in body
|
| May 26, 2021 at 16:05 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
deleted 2 characters in body
|
| Mar 17, 2021 at 16:09 | comment | added | DiddleDot | This answer helped me understand it best. Thank you. | |
| Feb 8, 2021 at 9:55 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
added 5 characters in body
|
| Jan 12, 2021 at 8:29 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
added 4 characters in body
|
| Jan 12, 2021 at 8:02 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
added 4 characters in body
|
| Dec 9, 2020 at 22:54 | history | edited | Ahmad Mobaraki | CC BY-SA 4.0 |
added 30 characters in body
|
| Nov 18, 2020 at 9:16 | history | answered | Ahmad Mobaraki | CC BY-SA 4.0 |