错误原因:select 列中没有在group by 列中
SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxx' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
修改my.ini文件 添加配置项
[mysqld]
sql-mod[mysqld]e=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES