Re: create alias for columns bound to database?

2012-05-21 Thread Johan De Meersman
- Original Message - From: Rick James rja...@yahoo-inc.com * should not begin with the table name Personally, I tend to prefix all column names with three-letter abbreviations of the table name, so that they are both unique across joins, and it's obvious what table they're from

RE: create alias for columns bound to database?

2012-05-21 Thread Rick James
, May 21, 2012 5:27 AM To: Rick James Cc: da...@lorenso.com; mysql@lists.mysql.com Subject: Re: create alias for columns bound to database? - Original Message - From: Rick James rja...@yahoo-inc.com * should not begin with the table name Personally, I tend to prefix all column

create alias for columns bound to database?

2012-05-18 Thread D. Dante Lorenso
All, I'd like to be able to create column aliases which are bound to the database itself. I have an assortment of columns without naming standards which i'd like to migrate to a better naming scheme. Is there a feature in MySQL that would allow me to give a database column multiple names?

RE: create alias for columns bound to database?

2012-05-18 Thread David Lerer
@lists.mysql.com Subject: create alias for columns bound to database? All, I'd like to be able to create column aliases which are bound to the database itself. I have an assortment of columns without naming standards which i'd like to migrate to a better naming scheme. Is there a feature in MySQL

RE: create alias for columns bound to database?

2012-05-18 Thread Rick James
18, 2012 2:22 PM To: mysql@lists.mysql.com Subject: create alias for columns bound to database? All, I'd like to be able to create column aliases which are bound to the database itself. I have an assortment of columns without naming standards which i'd like to migrate to a better naming