What's your advice on column naming conventions?
* 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:dante@stripped]
> Sent: Friday, May 18, 2012 2:22 PM
> To: firstname.lastname@example.org
> 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: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql