#4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'itripdb.store

报错信息

Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘itripdb.store.store’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决方案

1. 打开命令窗口，进入mysql的bin路径

2. 输入

    select @@session.sql_mode;
   

进行查询（如图）如果没有画圈这个那可以去找其他解决方案了：

3. 修改（输入下面语句即可）

	set @@session.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION ';

4. 查看
   

这就可以咯，但是重启后又要重新设置！