List:General Discussion« Previous MessageNext Message »
From:David Lerer Date:May 18 2012 9:36pm
Subject:RE: create alias for columns bound to database?
View as plain text  
Dante, consider using views that are defined with your alternate column names and present
the application with these views rather than underlying table names.

-----Original Message-----
From: D. Dante Lorenso [mailto:dante@stripped] 
Sent: Friday, May 18, 2012 5:22 PM
To: mysql@stripped
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?

-- Dante

D. Dante Lorenso

MySQL General Mailing List
For list archives:
To unsubscribe:

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.
create alias for columns bound to database?D. Dante Lorenso18 May
  • RE: create alias for columns bound to database?David Lerer18 May
  • RE: create alias for columns bound to database?Rick James18 May
    • Re: create alias for columns bound to database?Johan De Meersman21 May
      • RE: create alias for columns bound to database?Rick James21 May