MySQL Database-warning issues

The following error was reported when the MySQL client executed the delete DELETE statement:
Problem:
[ERR] 1055-expression #1 of ORDER by clause are not in GROUP by clause and
Contains nonaggregated column ' Information_schema. PROFILING. SEQ '
Which is not functionally dependent on columns in GROUP by clause;
This was incompatible with sql_mode=only_full_group_by
Workaround:

Use the VI command to edit the file, adding the following statement:
Sql_mode= ' Strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto_create_user,no_ Engine_substitution '
After saving, restart the MySQL service
The solution is complete!

MySQL Database-warning issues