Row count
All records via information_schema
select table_rows
from information_schema.tables
where table_schema = '<database name>'
and table_name = '<database table>';
select table_rows
from information_schema.tables
where table_schema = '<database name>'
and table_name = '<database table>';