>-----Original Message----- >From: David Lerer [mailto:dle...@us.univision.com] >Sent: Wednesday, August 03, 2011 10:25 AM >To: mysql@lists.mysql.com >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: je...@gii.co.jp Web site: www.giiresearch.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org