navicat for mysql，error1055，怎么解决

Question

[SQL]USE gramed; 受影响的行: 0 时间: 0.001s [Err] 1055 - Expression #1 of ORDER BY clause is 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 is incompatible with sql_mode=only_full_group_by 用了网上的方法，修改my.ini文件配置，但是还是没有解决，打出来还是这样，有没有大佬教教我呀

Answer 1

你这个是写的SQL语句错了。Order by 后面的字段列表必须在group by后面出现的才能用。