mysql使用group by不规范,导致SELECT list is not in GROUP BY clause and contains nonaggregated column
select *,count(distinct fittings_list_code) from fittings_listwhere approval_status = '0'group by fittings_list_code数据库查询操作大致如上(别问我为啥能写出来这么逗的数据库查询语句,反正就想对fittings_list_code这个字段去下重,用distinct+group...
原创
2020-03-06 11:22:15 ·
26257 阅读 ·
1 评论