What's your advice on column naming conventions? I say * should not begin with the table name * ids should be spelled the same between tables (`foo_id` both where it is the PK, and where it is a FK)
> -----Original Message----- > From: D. Dante Lorenso [mailto:da...@lorenso.com] > Sent: Friday, May 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 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 > da...@lorenso.com > 972-333-4139 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
