场景:
sql进行分组时报:which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决方案:
windows修改my.ini文件,linux修改my.cnf,更新sql-mode:
sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
mysql报this is incompatible with sql_mode=only_full_group_by
于 2023-09-25 16:19:05 首次发布