laravel 的group by报错
出错提示: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'kuaig »
一、Mysql优化 培训人:张哲荣 二、InnoDB 事务隔离级别 培训人:陈鑫昌 日期:2022年08月17日 周三 课程附件下载 »
出错提示: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'kuaig »
1.先去修改表字段字符集为utf8mb4: ALTER TABLE UGCREVIEWCONTENT MODIFY CONTENT TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4unicodeci COMMENT '评论内容'; 执行完后 »