Get Record Count of Tables in MySQL Example

Get Record Count of a specific Table in MySQL. SELECT SUM(TABLE_ROWS) as ‘Total Record Count’ FROM information_schema.TABLES WHERE table_schema = ‘$DATABASE_NAME’ AND table_name = ‘$TABLE_NAME’; Get Record Count of all Tables of a specific schema in MySQL. SELECT SUM(TABLE_ROWS) as ‘Total Record Count’ FROM information_schema.TABLES WHERE table_schema = ‘$DATABASE_NAME’; Get Record Count of all Tables … Read more