MySQL Database learning "supplemental" MySQL 5.7.9 version sql_mode=only_full_group_by issue

When querying a GROUP BY statement 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 Grou P BY clause; This is incompatible with sql_mode=only_full_group_by error

Workaround (Modify Global): Execute set global sql_mode = '; Change the Sql_mode to non-only_full_group_by mode. Verify that the SELECT @ @GLOBAL is in effect. Sql_mode or select @ @sql_mode

Execute (just modify the session level, only the current session takes effect) set session Sql_mode = '; Change the Sql_mode to non-only_full_group_by mode. Verify that the SELECT @ @GLOBAL is in effect. Sql_mode or select @ @sql_mode

MySQL Database learning "supplemental" MySQL 5.7.9 version sql_mode=only_full_group_by issue