llydependentoncolumnsinGROUPBYclause；thisisincompatiblewithsql_m

报错

ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘jol.solution.nick’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode&＃61;only_full_group_by

关键词&＃xff1a;only_full_group_by

查询查看sql_mode中的内容

mysql> select &＃64;&＃64;GLOBAL.sql_mode;
&＃43;-------------------------------------------------------------------------------------------------------------------------------------------&＃43;
| &＃64;&＃64;GLOBAL.sql_mode |
&＃43;-------------------------------------------------------------------------------------------------------------------------------------------&＃43;
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
&＃43;-------------------------------------------------------------------------------------------------------------------------------------------&＃43;
1 row in set (0.05 sec)


临时解决

set &＃64;&＃64;GLOBAL.sql_mode&＃61;&＃39;STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION&＃39;;


永久解决

在my.ini文件添加如下&＃xff0c;即删除ONLY_FULL_GROUP_BY

sql_mode&＃61;STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION