Solve the Problem of MySQL 5.7.9 SQL _mode = only_full_group_by, 5.7.9sql _ mode

Solve the Problem of MySQL 5.7.9 SQL _mode = only_full_group_by, 5.7.9sql _ mode

MySQL 5.7.9 SQL _mode = only_full_group_by

Com. mySQL. jdbc. exceptions. jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in group by clause and contains nonaggregated column 'col _ user_6.a.START_TIME 'which is not functionally dependent on columns in group by clause; this is incompatible with SQL _mode = only_full_group_by Error

Solution:

Run set global SQL _mode = ''; change SQL _mode to non-only_full_group_by mode.

Verify whether the SELECT @ GLOBAL. SQL _mode or SELECT @ SQL _mode takes effect

SET SQL _mode = 'strict _ TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGI

The above section describes how to solve the problem of MySQL 5.7.9 SQL _mode = only_full_group_by. I hope it will help you. If you have any questions, please leave a message and I will reply to you in time. Thank you very much for your support for the help House website!