From: David Lerer
Date: May 18 2012 9:36pm
Subject: RE: create alias for columns bound to database?
List-Archive: http://lists.mysql.com/mysql/227457
Message-Id: <54CA41808CE65943855971AE22F52C05118A5F90@EWR-EXMBX03.utg.uvn.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Dante, consider using views that are defined with your alternate column nam=
es and present the application with these views rather than underlying tabl=
e names.
David.

-----Original Message-----
From: D. Dante Lorenso [mailto:dante@stripped]=20
Sent: Friday, May 18, 2012 5:22 PM
To: mysql@stripped
Subject: create alias for columns bound to database?

All,

I'd like to be able to create column aliases which are bound to the=20
database itself.  I have an assortment of columns without naming=20
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=20
column multiple names?  I'm thinking that for SELECT * statements, you=20
would use the default column name, but for insert, delete, update, etc,=20
it would be fine to use the aliased name or default.

Doing this would *really* help to allow me to migrate the database to=20
the new naming convention without breaking existing code.  I would then=20
be able to refactor at a more leisurely pace.

Does the feature exist, or can it be created?

-- Dante

D. Dante Lorenso
dante@stripped
972-333-4139

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql


The information contained in this e-mail and any attached 
documents may be privileged, confidential and protected from 
disclosure.  If you are not the intended recipient you may not 
read, copy, distribute or use this information.  If you have 
received this communication in error, please notify the sender 
immediately by replying to this message and then delete it 
from your system.