Re: Fastest way to get table records' number
| From: | Nathan Nobbe | Date: | Wed, 19 Mar 2008 14:35:16 +0000 |
| Subject: | Re: Fastest way to get table records' number | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-271785@lists.php.net to get a copy of this message | ||
On Wed, Mar 19, 2008 at 9:42 AM, Andrew Ballard <aballard@gmail.com> 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