mysql中count(*)与count(column_name)的区别:
count(*)不忽略null,count(column_name)忽略null值!
还有其他聚合函数avg(),max()等
mysql 5.5版本3200万数据在加索引 仅需4分钟
alter table mid_message add key(staff_id);
Query OK, 0 rows affected (3 min 42.12 sec)Records: 0 Duplicates: 0 Warnings: 0