MYSQL Tip : how to get all tables with there record counts

SELECT table_name,TABLE_ROWS
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = ‘npr’;