解决mysql报Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的错误

用这行命令查询一下mysql的相关配置  SELECT @@sql_mode

如果查询出来的结果中有ONLY_FULL_GROUP_BY，那么此方法能解决报错问题

1.  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`;

某些版本会提示ariable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' 不能设置NO_AUTO_CREATE_USER的值，那么就用第二步

2.  SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

设置完后，直接重启navicat就好了