Mysql5.7提示错误only full group by...

SELECT list is not in GROUP BY clause and contains nonaggregated column .... incompatible with sql_mode=only_full_group_by....

Mysql 5.7版本提示以上错误。解决方法之一：

通过运行以下命令禁用ONLY_FULL_GROUP_BY 模式

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