mysql 增删改查时报错1055 - Expression 原因

报错的完整信息如下：

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

试了navicat 的10.0.5，11.0.17,12.0.29三个版本，发现就11.0.17有问题，最后官网上找到说是navicat 客户端版本问题

连接：http://community.navicat.com/forum/navicat-product/navicat-for-mysql/4456-profiling-in-navicat-throws-err-1055-for-every-query-starting-with-mysql-5-7-5