MySQL 分组查询时报错 mysql this is incompatible with sql_mode=only_full_group_by
mysql 5.7
[mysqld] sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
mysql 8
sql_mode='STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'
标签:full,group,incompatible,sql,only,mode,mysql From: https://www.cnblogs.com/sanrenblog/p/16909615.html