84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
有一个Mysql数据表记录客户信息id name province1 张三 北京2 李四 北京3 王二 河北4 赵丰 河北5 刘飞 河北6 贾有 湖北7 朱涛 湖南如何用一句SQL求出各省人数?SELECT COUNT(PROVINCE) FROM TABLE GROUP BY PROVINCE可以吗?如何用PHP显示出来?
SELECT province, COUNT( province ) FROM test GROUP BY province
可以。楼上取出数据集。再用foreach遍历一下就好了
foreach
可以。楼上取出数据集。再用
foreach
遍历一下就好了