解决Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

解决Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

解决方法：

报错信息如下：

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'thinkcc_nps.a.create_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

修改mysql安装目录下的配置文件my.cnf，把sql_mode属性的ONLY_FULL_GROUP_BY去掉，重启mysql即可

顶

0