D. Dante Lorenso create alias for columns bound to database?
May 18, 2012; 16:21
D. Dante Lorenso
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 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 dante@lorenso.com 972-333-4139
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
May 18
David Lerer RE: create alias for columns bound to database?
May 18, 2012; 17:36
David Lerer
RE: create alias for columns bound to database?
May 18
Rick James RE: create alias for columns bound to database?
May 18, 2012; 14:58
Rick James
RE: create alias for columns bound to database?
May 21
Johan De Meersman Re: create alias for columns bound to database?
May 21, 2012; 14:27
Johan De Meersman
Re: create alias for columns bound to database?
May 21
Rick James RE: create alias for columns bound to database?
May 21, 2012; 11:57
Rick James
RE: create alias for columns bound to database?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!