[mySQL] counting rows in multiple tables

[Anon]

Heho,
I got several tables in my database and I'm trying to figure out how to get the total number of rows in more than one table. Any hints appreciated.

tia, jt - please visit http://www.dogabi2001.de

[Anon]

You could do a count(*) on a join select.

select count(*) from table1, table2
where table1.referance_id = table2.referance_id

but this will only work if you have a way of linking the two tables. If you only want total rows from each just run a count(*) select on each.

[Anon]

Thanks for taking the time to post this information.