this is incompatible with sql_mode=only_full_group_by 根本上解决

该文件位于   /etc/my.cnf,在[mysqld] 下面添加,sql-mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

原文地址:https://www.cnblogs.com/St123456/p/15305002.html