Re: Counting multiple tables

2004-05-17 Thread Michael Stassen
Sasha Pachev wrote: Gustavo Andrade wrote: I want to know if its possible to count the total records of multiple tables: Example: I have 3 tables. I want to know the total records of each table using only 1 query. Is that possible? It is actually possible with 4.0, although rather convoluted: (se

Re: Counting multiple tables

2004-05-17 Thread Paul DuBois
At 21:17 -0600 5/17/04, Sasha Pachev wrote: Gustavo Andrade wrote: I want to know if its possible to count the total records of multiple tables: Example: I have 3 tables. I want to know the total records of each table using only 1 query. Is that possible? It is actually possible with 4.0, although

Re: Counting multiple tables

2004-05-17 Thread Sasha Pachev
Gustavo Andrade wrote: I want to know if its possible to count the total records of multiple tables: Example: I have 3 tables. I want to know the total records of each table using only 1 query. Is that possible? It is actually possible with 4.0, although rather convoluted: (select count(*) from f

Re: Counting multiple tables

2004-05-17 Thread Egor Egorov
"Dathan Vance Pattishall" <[EMAIL PROTECTED]> wrote: > SHOW TABLE STATUS to get the count of each table, then your application = > adds > the number in the Rows field from each of the tables returned. For InnoDB tables SHOW TABLE STATUS returns approximate row count. > > >> -Original Messag

RE: Counting multiple tables

2004-05-16 Thread Dathan Vance Pattishall
SHOW TABLE STATUS to get the count of each table, then your application adds the number in the Rows field from each of the tables returned. DVP Dathan Vance Pattishall http://www.friendster.com > -Original Message- > From: Gustavo Andrade [mailto:[EMAIL PROTECTED] > Sent: Sunda