distal-attribute
distal-attribute
distal-attribute
distal-attribute

why this behaviour?

markzzz posted 3 years ago in General
When I try to show my tables on HeidiSql (and refresh the database), I notice this (you can see the screenshoot after 3 refresh in few seconds) :

screenshot1
screenshot2
screenshot3

The rows for those tables are different at any refresh! What?
kalvaro posted 3 years ago
That's because your tables are InnoDB. In such engine, the row count is approximate:

http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html

Scroll down to InnoDB does not keep an internal count of rows in a table.
markzzz posted 3 years ago
ah the row count is approximate...ok thanks! :)
Augusto posted 2 years ago
Good to know.. wink

Please login to leave a reply, or register at first.