MySQL报错：1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated col_mysql 8 1055 - expression #1 of select list is not

作者：小舞很执着 | 2024-07-29 15:47:47

踩

mysql 8 1055 - expression #1 of select list is not in group by clause and co

遇到问题：

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '字段' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决办法：

输入

set sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

再进行group by 就可以啦

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