>-----Original Message-----
>From: David Lerer [mailto:DLerer@stripped]
>Sent: Wednesday, August 03, 2011 10:25 AM
>To: mysql@stripped
>Subject: RE: Too many aliases
>
>I rarely use aliases (unless rarely required in self-join queries).
>Yes, the column names may be longer this way, but easy to refer to and
>easy to communicate (by specifying a table number). I wonder what others
>think about it.
>
[JS] Back when I was trying to fit as much code on a punch-card as possible,
the languages only supported short names, and the terminals ran at 10cps,
every keystroke was precious.
Now I routinely pay the price of extra keystrokes for readability: not just
with things such as column names, but with parentheses and the like as well.
Like you, I only use aliases when necessary.
If I want brain-teasers, I'll do a crossword puzzle.
But that's just me.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
Web site: www.giiresearch.com
