阅读背景:

为什么行返回“explain”不等于count()?

来源:互联网 
    mysql> select count(*) from table where relation_title='xxxxxxxxx';
+----------+
| count(*) |
+----------+
|  1291958 |
+----------+

mysql> explain select *  from table where relation_title='xxxxxxxxx';
+----+-------------+---------+-
| id | select_type | rows    |
+----+-------------+---------+-
|  1 | SIMPLE      | 1274785 | 
+----+-------------+---------+-
    mysql> select count(*) from table where rel



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: