错误代码: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

错误代码: 1055

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gold_chicken_farm.dmooo_trade_eggs.id' 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';

最后编辑于:2020/12/02作者: 牛逼PHP

发表评论