数据库报错：SELECT list is not in GROUP BY clause_phpstudy中sql front连接数据库时出现 not in group by

作者：代码探险家 | 2024-07-29 15:51:52

踩

phpstudy中sql front连接数据库时出现 not in group by

mysql5.7使用group by出现错误：

[Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.score.c_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

phpstudy解决方法：在phpstudy的mysql.ini文件中添加

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/代码探险家/article/detail/899558