How to learn rows number of different tables with one MySQL query?

Question

I have different MySQL tables such as users, news and etc. I want to know users number, news number with one MySQL query. How can I do that?

possible duplicate of [Select count(*) from multiple tables](http://stackoverflow.com/questions/606234/select-count-from-multiple-tables) — Michael Mior, Oct 25 '11 at 14:00

score 0 · Answer 1 · answered Oct 25 '11 at 13:51

0

Use a UNION.

SELECT 'users', COUNT(*) as c FROM users UNION SELECT 'names', COUNT(*) as c FROM names;

answered Oct 25 '11 at 13:51

tdammers

1 Answers1