> Bryan Irvine wrote:
> Is there an easy way to count how many records there are?
On Wed, 10 Sep 2003 18:26:30 +0100
Simon Willison <cs1spw(at)bath(dot)ac(dot)uk> wrote:
> Yes, using count(*):
> select count(*) from tablename;
Is there any performance difference in explicitly naming a column to
count?
i.e select count(id) from tablename;
(I know that a lot of beginners always "select *" even when they don't
need all the information which (I think) is slower than selecting just
what need.)