SELECT CONCAT('SELECT COUNT(*) FROM ', table_name) FROM information_schema.tables WHERE table_schema = 'Tables';
 
CREATE SELECT TOTAL ROWS FOR ALL TABLES IN A DATABASE