this is incompatible with sql_mode=only_full_group_by

mysql8.0解决：this is incompatible with sql_mode=only_full_group_by

在mysqld下添加：
sql_mode ='STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'