Mysql : Displaying number of rows for every table in a given database

select table_name, table_rows from information_schema.tables where table_schema = 'Database_to_look';
Source