Re: Number of records in a table

[Peter Brawley]

Rowcounts in non-transactional tables (eg MyISAM) are given by ...

select count(*) from tablename;

In a transactional (ie InnoDB) table, the issue is more complicated---there may be insertions or deletions hidden in transactions which your executing client has no access to, the above query gives only an estimate, there is no such thing as a provably correct rowcount, eg see https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_stats_on_metadata