MySQL 5.7 Version sql_mode=only_full_group_by issue

Specific error:

SQLSTATE[42000]: Syntax error or Access violation:1055 Expression #1 of SELECT list is not in GROUP by clause and contain S nonaggregated column ' Library. table. field ' which is not functionally dependent on columns in GROUP by clause; This was incompatible with sql_mode=only_full_group_by

View:

View MySQL's Global.sql_mode

SELECT @ @global. sql_mode;

Displayed as follows: Only_full_group_by,strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto_ Create_user,no_engine_substitution

Solve

Modify Global.sql_mode

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 5.7 Version sql_mode=only_full_group_by issue