SELECT COUT(主键)、count(1)、count(*)的区别
解决方案 »
- 去重复值sql语句怎么写
- SQL查询急求帮助!!!!!!!!!!!!
- 又见乱码问题!!eclipse、mysql、navicat编码如何统一?急!
- mysql---在存储过程中使用LIKE关键字匹配查询。为什么不能查出结果?
- 得到文章的前一条,后一条记录
- 高分请教:批量删除SQL语句
- mysql innodb 外键的原理?
- log型表,group无法取出完整数据
- ubuntu14.04 下 mysql -uroot -p 输入密码后报错
- Mysql:ERROR 2003 (HY000) 110错误 防火墙关闭,telnet对应端口也能通
- shell怎么进入?(mysql)
- 怎么玩的,我倒。。。 if问题
+----+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Select tables optimized away |
+----+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
1 row in set (0.00 sec)mysql> explain select count(*) from table1;
+----+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Select tables optimized away |
+----+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
1 row in set (0.00 sec)mysql> explain select count(id) from table1;
+----+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Select tables optimized away |
+----+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
select count(1) from table的效率更好。
其他两个能得出相同结果。
有区别的