Re: [Nolug] Verbose SQL

Chris Reames wrote:

> Select Democrats=(select count(voters) from tbl_state_list where vote LIKE
> 'yes', Republicans=(select count(voters) from tbl_state_list where vote LIKE
> 'no', Totals=(select count(voters) from tbl_state_list where vote is not
> null) from tbl_state_list where st_code='Florida'

Since you aren't the first to do this, I'll ask: why include "tbl" in
the name of a database table? Should we put "col" or "fld" in the names
of the columns of the table? Or "db" in the name of the database we
connect to?

It seems redundant: why do it?

Mark.
___________________
Nolug mailing list
nolug@nolug.org
Received on 09/29/04