How to disable only_full_group_by

Discussion in 'MySQL' started by lapidus, May 7, 2020.

0
  1. #1
    Hello

    So, i need to disable only_full_group_by mode on my server.

    Please i need step by step explanation.

    Thanks
     
    Last edited: May 7, 2020
    lapidus, May 7, 2020 IP
  2. JEET

    JEET Notable Member

    Messages:
    3,832
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #2
    I think you will have to edit the conf file of MySQL for this. I think its called my.cnf or MySQL.cnf or something like that.
    You will need to edit the variable sql_mode
     
    JEET, May 7, 2020 IP
  3. qwikad.com

    qwikad.com Illustrious Member Affiliate Manager

    Messages:
    7,255
    Likes Received:
    1,690
    Best Answers:
    31
    Trophy Points:
    475
    #3
    qwikad.com, May 8, 2020 IP
    JEET likes this.