Mysql Version 5.7 Error 1055

Error message:

[ERR] 1055-expression #1 of ORDER by clause are not in GROUP by clause and contains nonaggregated column ' Information_sch Ema. PROFILING. SEQ ' which is not functionally dependent on columns in GROUP by clause; This was incompatible with sql_mode=only_full_group_by

Workaround:

For the error err1055 query for a long time, said that the 5.7 version of the SQL packet query has a syntax detection, for the previous SQL will have some errors, as long as the Sqlmodel in the only_full_group_by to remove the line.

#查询sqlmodel模式: SELECT @ @global. sql_mode

Set Sqlmodel 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 Version 5.7 Error 1055