Dante, consider using views that are defined with your alternate column names and present
the application with these views rather than underlying table names.
From: D. Dante Lorenso [mailto:dante@stripped]
Sent: Friday, May 18, 2012 5:22 PM
Subject: create alias for columns bound to database?
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? I'm thinking that for SELECT * statements, you
would use the default column name, but for insert, delete, update, etc,
it would be fine to use the aliased name or default.
Doing this would *really* help to allow me to migrate the database to
the new naming convention without breaking existing code. I would then
be able to refactor at a more leisurely pace.
Does the feature exist, or can it be created?
D. Dante Lorenso
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.