执行sql语句报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘www_tianhezz_net.j.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
1.select @@session.sql_mode; //查看sql_mode
2.set @@global.sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; //去除ONLY_FULL_GROUP_BY
3.重新启动navicat,切记不可重启mysql服务