- Original Message -
From: Rick James rja...@yahoo-inc.com
* should not begin with the table name
Personally, I tend to prefix all column names with three-letter abbreviations
of the table name, so that they are both unique across joins, and it's obvious
what table they're from
, May 21, 2012 5:27 AM
To: Rick James
Cc: da...@lorenso.com; mysql@lists.mysql.com
Subject: Re: create alias for columns bound to database?
- Original Message -
From: Rick James rja...@yahoo-inc.com
* should not begin with the table name
Personally, I tend to prefix all column
Dante, consider using views that are defined with your alternate column names
and present the application with these views rather than underlying table names.
David.
-Original Message-
From: D. Dante Lorenso [mailto:da...@lorenso.com]
Sent: Friday, May 18, 2012 5:22 PM
To:
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