MySQL:count(*),count(1),count(col)的区别

最近感觉大家都在讨论count的区别，那么我也写下吧：欢迎留言讨论
1、表结构：

dba_jingjing@3306>[rds_test]>CREATE TABLE `test_count` (
    ->   `c1` varchar(10) DEFAULT NULL,
    ->   `c2` varchar(10) DEFAULT NULL,
    ->   KEY `idx_c1` (`c1`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.11 sec)

2、插入测试数据：

dba_jingjing@3306>[rds_test]>insert into test_count values(1,10);
Query OK, 1 row affected (0.03 sec)

dba_jingjing@3306>[rds_test]>insert into test_count values(abc,null);
ERROR 1054 (42S22): Unknown column 'abc' in 'field list'
dba_jingjing@3306>[rds_test]>insert into test_count values('abc',null);
Query OK, 1 row affected (0.04 sec)

dba_jingjing@3306>[rds_test]>insert into test_count values(null,null);
Query OK, 1 row affected (0.04 sec)

dba_jingjing@3306>[rds_test]>insert into test_count values('368rhf8fj',null);
Query OK, 1 row affected (0.03 sec)

dba_jingjing@3306>[rds_test]>select * from test_count;
+-----------+------+
| c1        | c2   |
+-----------+------+
| 1         | 10   |
| abc       | NULL |
| NULL      | NULL |
| 368rhf8fj | NULL |
+-----------+------+
4 rows in set (0.00 sec)

测试：

>>>阅读全文