count()—计数函数 原表: MySQL 示例一: SELECT count(A) as "count(列名)", count(*) as "count(*)" FROM `测试表count` 执行结果如下: MySQL 示例二: SELECT count(b) as "count(列名)", count(*) as "count(*)" FROM `测试表count` 执行结果如下: 总结: count(列名) 只计数值不为null的行数 count(*) 计数的是整张表的行数 感悟:可以用count(*)计算一张表的行数