MYSQL count all rows per table for in one query

Question

Is there a way to query the DB to find out how many rows there are in all the tables

ie

table1 1234
table2 222
table3 7888

Hope you can advise

Answer 1

SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES

Answer 2

SELECT TABLE_NAME, TABLE_ROWS FROM `information_schema`.`tables` WHERE `table_schema` = 'YOUR_DB_NAME';

Answer 3

select sum(cnt) from
(
select count(*) as cnt from table1
union
select count(*) as cnt from table2
union 
select count(*) as cnt from table3 
)t1