how to enable/disable ONLY_FULL_GROUP_BY error in MySQL | change sql mode permanently [Fixed]

Опубликовано: 13 Март 2025
на канале: GSoft Knowledge

10,570

disable permanently error "Expression #N of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db.table.COL' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"

Watch the video till the end to understand.

code and paste this:

[mysqld]
... other stuff will probably be here
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
group_concat_max_len=2000000

==============================================
FOR FASHION ACCESSORIES AND SHOES FOLLOW MY PAGE

👇 👇 👇 LINK TO INSTAGRAM PAGE 👇 👇 👇

Page Link: / kicksniks_official

PAGE NAME: kicksniks
FREE SHIPPING ALL OVER INDIA
Must follow my instagram page
---------------------------------------------------------

Dont forget to like, share and Subscribe.