Re: [Nolug] Verbose SQL

Mark A. Hershberger wrote:

> 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
>
It sounds too much like the MS Access naming convention, besides being
unnecessary with newer tools.
___________________
Nolug mailing list
nolug@nolug.org
Received on 09/29/04