Row count

All records via information_schema

select table_rows
  from information_schema.tables
 where table_schema = '<database name>'
   and table_name = '<database table>';