How to disable ONLY_FULL_GROUP_BY in mysql ?

QuestionsCategory: MySQLHow to disable ONLY_FULL_GROUP_BY in mysql ?
Johny asked 3 months ago

Everytime when i restart my database server or my pc, i am facing the issue, how i can fix this issue ?

1 Answers
Best Answer
Amit Kumar Staff answered 3 months ago

Solution 1 : Remove ONLY_FULL_GROUP_BY from mysql console.

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Solution 2: Remove ONLY_FULL_GROUP_BY from phpmyadmin.

  • Open phpmyadmin & select localhost
  • Click on menu Variables & scroll down for sql mode
  • Click on edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save.