Answers for "show number of records in mysql table"

count of tables in database mysql

SELECT count(*) 
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'database_name'

Posted by: Guest on November-10-2020

how to check which table has data in mysql

mysql> SELECT table_name, table_rows
   ->FROM INFORMATION_SCHEMA.TABLES
   ->WHERE TABLE_SCHEMA = 'business';

Posted by: Guest on May-20-2020

Code answers related to "show number of records in mysql table"