解决MySQL版本‘sql_mode=only_full_group_by’引起的查询错误 | 你所不知道的物語;

[Echo-xzp]

https://www.hitagi.icu/posts/c0d9da45/

博主在部署一个项目后进行测试，发现了一个界面报服务器500错误，于是查看报错误日志： 1Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'study.user_study.chapter_id' which is not functionally d