/* Total rows in database Use DATABASE() for current DB*/
SELECT table_name, table_rows
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = DATABASE()
UNION    
SELECT 'Total' AS table_name, SUM(TABLE_ROWS) AS table_rows
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = DATABASE();  
