Well ...
I don't know enough about mysql but it must allow you somehow to specify the
column by number as in Oracle and other DBs
SQL> select count(*) from product;
COUNT(*)
----------
10
SQL> select count(1) from product;
COUNT(1)
----------
10
Once you just want to count the rows the performance of your select will be
much better if you specify a column rather than *.
Siomara
>From: "Ansgar Becker" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: count(*) on different tables
>Date: Mon, 21 May 2001 20:18:35 +0200
>
>Hi,
>
>is it possible to get *one* quick result with the rowcount of each table in
>one database, without knowing the column-names?
>
>this does *not* work:
> select count(t1.*), count(t2.*)
> from table1 t1, table2 t2
>
>Manual doesn't say anything about that.
>
>Greetings,
>Ansgar Becker
>
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php