#Solved - ERROR Only_full_group_by When Executing a Query in MYSQL

How to solved ERROR Only_full_group_by When Executing a Query in MYSQL? this tutorial will show you how to disable the only_full_group_by in MySQL

CRUD OPERATION REST API using PHP and MYSQLI

How Does PHP While Do-While For & Foreach Loops Works???

How to Write Good Code & Become a Professional Programmer

Reject queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are functionally dependent on (uniquely determined by) GROUP BY columns.

As of MySQL 5.7.5, the default SQL mode includes ONLY_FULL_GROUP_BY. (Before 5.7.5, MySQL does not detect functional dependency and ONLY_FULL_GROUP_BY is not enabled by default. For a description of pre-5.7.5 behavior.

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by

A MySQL extension to standard SQL permits references in the HAVING clause to aliased expressions in the select list. Before MySQL 5.7.5, enabling ONLY_FULL_GROUP_BY disables this extension, thus requiring the HAVING clause to be written using unaliased expressions. As of MySQL 5.7.5, this restriction is lifted so that the HAVING clause can refer to aliases regardless of whether ONLY_FULL_GROUP_BY is enabled.

SELECT testuser_id,
    testuser_test_id,
    testuser_creation_time,
    testuser_status,
    user_id,
    user_name,
    testlog_question_id,
    question_description,
    testuser_test_id,
    sum(testlog_score) as benar,
    count(testlog_question_id) as jumlahsoal
FROM tce_tests_logs, tce_tests_users, tce_users, tce_questions
WHERE testlog_testuser_id=testuser_id AND testuser_user_id=user_id AND question_id=testlog_question_id AND testuser_test_id=5 group by user_id order by benar ASC

I have upgraded my system and have installed MySql 5.7.9 with php for a web application I am working on. I have a query that is dynamically created, and when run in older versions of MySql it works fine. Since upgrading to 5.7 I get this error:

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'support_desk.mod_users_groups.group_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

#Solved

You can turn off the warning message as explained in the other answers or you can understand what's happening and fix it.

Update your MySQL configuration in C:\server\mysql\bin\my.ini

[mysqld]
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

or from console you can change the default values :

mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

and then please restart your MYSQL services.