1、MySQL8.0进行 group_by 和 order by 时 出现报错信息
mysql8.0 this is incompatible with sql_mode=only_full_group_by
# 设置mysql 处理模式
sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
1、MySQL8.0进行 group_by 和 order by 时 出现报错信息
mysql8.0 this is incompatible with sql_mode=only_full_group_by
# 设置mysql 处理模式
sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"