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 | |
|---|---|---|---|---|---|
| Jul 13, 2023 at 8:23 | comment | added | risingStark | @RakeshSoni can u mention the syntax for newer versions of mysql as well as this syntax in point 3 does not allow restarting mysql server > 5.7. UPDATE: Newer versions of Mysql (e.g. 5.7.8 or above) may require slightly different syntax: [mysqld] sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" | |
| Dec 2, 2021 at 13:48 | history | edited | Rakesh Soni | CC BY-SA 4.0 |
edited body
|
| S Dec 2, 2021 at 6:20 | history | suggested | tolik518 | CC BY-SA 4.0 |
added backticks for readability
|
| Dec 1, 2021 at 14:33 | review | Suggested edits | |||
| S Dec 2, 2021 at 6:20 | |||||
| Oct 26, 2021 at 8:08 | comment | added | w.Daya |
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); This is working fine for me.
|
|
| Sep 21, 2021 at 10:18 | comment | added | Ehsan Sarshar | I have removed that option. but still I see the error | |
| Aug 2, 2021 at 8:08 | history | edited | Rakesh Soni | CC BY-SA 4.0 |
added 1 character in body
|
| Jul 31, 2021 at 6:24 | history | edited | Rakesh Soni | CC BY-SA 4.0 |
added 695 characters in body
|
| Feb 22, 2021 at 14:05 | history | edited | Rakesh Soni | CC BY-SA 4.0 |
added 284 characters in body
|
| Feb 12, 2021 at 6:33 | history | edited | Rakesh Soni | CC BY-SA 4.0 |
added 37 characters in body
|
| Oct 29, 2020 at 6:34 | comment | added | Rakesh Soni | (1) Change the file permission of file my.cnf by using the command "chmod". (2) Perform changes in my.cnf (3) set it read-only again (change file permission again using "chmod") (4) restart mysql | |
| Oct 29, 2020 at 3:20 | comment | added | Sanmitha Sadhishkumar | Thank you so much for the above answer. I want to change this as you said in my my.cnf. But when I open that file, it opens only in read-only mode. Any helps or reference links???. I use Ubuntu 16.04 | |
| S Oct 9, 2020 at 11:44 | history | suggested | andyface | CC BY-SA 4.0 |
add \ to escape * in title as this was preventing the markup from working properly as well as fix typo
|
| Oct 9, 2020 at 11:28 | review | Suggested edits | |||
| S Oct 9, 2020 at 11:44 | |||||
| Aug 25, 2020 at 6:40 | history | edited | kirtan403 | CC BY-SA 4.0 |
Highlighting only 1 solution to be used
|
| May 13, 2020 at 8:58 | history | edited | Rakesh Soni | CC BY-SA 4.0 |
added 4 characters in body
|
| Aug 8, 2018 at 5:59 | history | edited | Rakesh Soni | CC BY-SA 4.0 |
added 486 characters in body
|
| Aug 1, 2018 at 9:06 | history | edited | Rakesh Soni | CC BY-SA 4.0 |
added 9 characters in body
|
| Aug 1, 2018 at 9:01 | history | answered | Rakesh Soni | CC BY-SA 4.0 |