Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated...
记一个MySql的小坑,在Mysql版本为5.7.25时,在使用使用group by 时,会出现Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated...错误,这个错误的原因是 group by后面需要加上,select中的所有字段。不然就会报这个错误。解决这个错误方法是更改Linu...
原创
2019-11-26 16:38:35 ·
2201 阅读 ·
0 评论