MYSQL – count number of rows in each table

SELECT table_name, table_rows
    FROM INFORMATION_SCHEMA.TABLES
    WHERE TABLE_SCHEMA = '<your db>';

I also hope you realise there’s an error in your query: it’s missing a FROM.