COUNT on more than 1 tables?

[earswithfeet]

Hi,

i want to show the number of entries in each table within my database.
I am currently doing this with:

SELECT COUNT() FROM table1
SELECT COUNT() FROM table2
SELECT COUNT() FROM table3
SELECT COUNT() FROM table4
...

However, is this possible to do in 1 query, which holds the name and the no of entries of each table in my database?

Thanks...

[chriskl]

Unions are your friend.

SELECT 'table1' AS name, COUNT() AS total FROM table1
UNION ALL
SELECT 'table2', COUNT() FROM table2
UNION ALL
SELECT 'table3', COUNT() FROM table3
UNION ALL
SELECT 'table4', COUNT() FROM table4;

[earswithfeet]

Thanks a lot.
I was curious, when it didn't work, but then i had to realize that it's a MySQL > 4.0.0. function and i have 3.x
DOH!