Nathan Nobbe wrote:
On Wed, Mar 19, 2008 at 9:42 AM, Andrew Ballard <aballard@xxxxxxxxx> wrote:
That works; I'm just wondering why you went with a count on an 'ID' column
rather than COUNT(*).
ouch, it looks like im horribly wrong :O
mysql> select count(*) from table;
+----------+
| count(*) |
+----------+
| 361724 |
+----------+
1 row in set (0.90 sec)
mysql> select count(id) from table;
+------------+
| count(did) |
+------------+
| 361724 |
+------------+
1 row in set (4.56 sec)
-nathan
Hi nanthan,
Thanks.
This is my test results:
mysql> select count(*) from article;
+----------+
| count(*) |
+----------+
| 1065868 |
+----------+
1 row in set (1.30 sec)
mysql> select count(1) from article;
+----------+
| count(1) |
+----------+
| 1065868 |
+----------+
1 row in set (0.82 sec)
mysql> select count(*) from article;
+----------+
| count(*) |
+----------+
| 1065868 |
+----------+
1 row in set (0.81 sec)
mysql> select count(id) from article;
+-----------+
| count(id) |
+-----------+
| 1065868 |
+-----------+
1 row in set (0.85 sec)
mysql> select count(1) from article;
+----------+
| count(1) |
+----------+
| 1065868 |
+----------+
1 row in set (0.82 sec)
mysql> select count(*) from article;
+----------+
| count(*) |
+----------+
| 1065868 |
+----------+
1 row in set (0.81 sec)
mysql> select count(id) from article;
+-----------+
| count(id) |
+-----------+
| 1065868 |
+-----------+
1 row in set (0.85 sec)
mysql> select count(1) from article;
+----------+
| count(1) |
+----------+
| 1065868 |
+----------+
1 row in set (0.81 sec)
Seems that count(1) is always not a bad answer.
So, I determined to choose count(1).
Thank you all for your replies.
--
Regards,
Shelley ( PHP Architecture: http://phparch.cn )
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
