这个屌丝很懒，什么也没留下！

数据库报错：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博客】