错误:
which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决:
进入mysql,执行命令
select @@sql_mode;
查出sql_mode的值删掉only_full_group_by,在my.cnf中添加
sql_mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION;
重启mysql