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
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
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
"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
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