EXPLAIN and COUNT returning two different values

Posted by every_answer_gets_a_point on Stack Overflow See other posts from Stack Overflow or by every_answer_gets_a_point
Published on 2010-06-02T21:30:02Z Indexed on 2010/06/02 21:34 UTC
Read the original article Hit count: 122

Filed under:
|

i am doing:

explain select * from calibration;

it says 521332 rows

when i do:

select count(*) from calibration;

i am getting 521961

can someone explain whats going on here?

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql