select count(tb_message.tbm_id) from tb_message; 1.124秒;
select count(*) from tb_message; 1.040秒;
select count(1) from tb_message; 1.024秒;
测试数据:6572027条,这是在生产环境测试,在不同时间可以得到不同的值,但是count(1)<=count(*)<count(字段)
select count(tb_message.tbm_id) from tb_message; 1.124秒;
select count(*) from tb_message; 1.040秒;
select count(1) from tb_message; 1.024秒;
测试数据:6572027条,这是在生产环境测试,在不同时间可以得到不同的值,但是count(1)<=count(*)<count(字段)