选择数据库中所有表中的行数

I wonder if this is possible with straight SQL on MySQL. I need to do SELECT COUNT(*) FROM on each table in the database and output results in one result set.I wonder if this is possible with straight SQL