1. COUNT(*)计算table的行数
计算pet表中的动物
mysql> select count(*) from pet; +----------+ | count(*) | +----------+ | 9 | +----------+ 1 row in set (0.00 sec) mysql>
计算每个人有多少宠物
mysql> select owner, count(*) from pet group by owner; +--------+----------+ | owner | count(*) | +--------+----------+ | Benny | 2 | | Diane | 2 | | Gwen | 3 | | Harold | 2 | +--------+----------+ 4 rows in set (0.04 sec) mysql>
每种类型的宠物数量