SELECT type, count(1) AS counts FROM material GROUP BY type 转载于:https://www.cnblogs.com/anxiaoyu/p/7087396.html