MYSQL8.0报错解决方案

//mysql8.0 Navicat Premium 15 使用 group by 报错

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘test_2.t_score.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
时间: 0s
————————————————
版权声明：本文为CSDN博主「努力的蚂蚁【你若】」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/qq_37758497/article/details/120333080

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION