469,326 Members | 1,351 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

naming standards

Does anyone know where I could find a consensus (in mysql community) on
naming conventions? Is there a published standard? I mean primarily the
naming of tables and fields.

Obviously, people use what works for them. But I'd like a look at any hard
and fast rules that all or most people stick to.
Jul 19 '05 #1
6 11390
Matthew,

If you're just talking about how to make names look in general....:
If you're a OO guru you'll probably want to use FieldNamesThatLookLikeThis.
If you want it to be readable by everyone else use_names_that_look_like_this.
Honestly, the underscores look much better. Spacing out names looks easier
than the German method noun of JammingNamesIntoOneAnotherAchtung!
Besides, if someone forgets to capitalize something, it will take forever to
figure out
what's going on.

Just my 2 cents.
....Don...

Matthew Crouch wrote:
Does anyone know where I could find a consensus (in mysql community) on
naming conventions? Is there a published standard? I mean primarily the
naming of tables and fields.

Obviously, people use what works for them. But I'd like a look at any hard
and fast rules that all or most people stick to.


Jul 19 '05 #2
Matthew,

If you're just talking about how to make names look in general....:
If you're a OO guru you'll probably want to use FieldNamesThatLookLikeThis.
If you want it to be readable by everyone else use_names_that_look_like_this.
Honestly, the underscores look much better. Spacing out names looks easier
than the German method noun of JammingNamesIntoOneAnotherAchtung!
Besides, if someone forgets to capitalize something, it will take forever to
figure out
what's going on.

Just my 2 cents.
....Don...

Matthew Crouch wrote:
Does anyone know where I could find a consensus (in mysql community) on
naming conventions? Is there a published standard? I mean primarily the
naming of tables and fields.

Obviously, people use what works for them. But I'd like a look at any hard
and fast rules that all or most people stick to.


Jul 19 '05 #3
Matthew,

If you're just talking about how to make names look in general....:
If you're a OO guru you'll probably want to use FieldNamesThatLookLikeThis.
If you want it to be readable by everyone else use_names_that_look_like_this.
Honestly, the underscores look much better. Spacing out names looks easier
than the German method noun of JammingNamesIntoOneAnotherAchtung!
Besides, if someone forgets to capitalize something, it will take forever to
figure out
what's going on.

Just my 2 cents.
....Don...

Matthew Crouch wrote:
Does anyone know where I could find a consensus (in mysql community) on
naming conventions? Is there a published standard? I mean primarily the
naming of tables and fields.

Obviously, people use what works for them. But I'd like a look at any hard
and fast rules that all or most people stick to.


Jul 19 '05 #4
Ray
"Matthew Crouch" <ma************@spamlessverizon.net> wrote in message news:<uX*****************@nwrddc02.gnilink.net>...
Does anyone know where I could find a consensus (in mysql community) on
naming conventions? Is there a published standard? I mean primarily the
naming of tables and fields.

Obviously, people use what works for them. But I'd like a look at any hard
and fast rules that all or most people stick to.


If you're hosting the db on a case-sensitive file system, then table
names will be case-sensitive. For this reason, I prefer to always use
lowercase for all table names (and field names for consistency). Then
you don't have to remember what case to use when.

I normally use name prefixes of "tblcbo_" for lookup tables, "tbllnk_"
for many-many link tables, "tbl_" for other tables. For other ideas,
try googling for "database naming conventions" - you'll get plenty of
reading material.

Ray Gurganus
Community IT Innovators
www.citidc.com
Jul 19 '05 #5
Ray
"Matthew Crouch" <ma************@spamlessverizon.net> wrote in message news:<uX*****************@nwrddc02.gnilink.net>...
Does anyone know where I could find a consensus (in mysql community) on
naming conventions? Is there a published standard? I mean primarily the
naming of tables and fields.

Obviously, people use what works for them. But I'd like a look at any hard
and fast rules that all or most people stick to.


If you're hosting the db on a case-sensitive file system, then table
names will be case-sensitive. For this reason, I prefer to always use
lowercase for all table names (and field names for consistency). Then
you don't have to remember what case to use when.

I normally use name prefixes of "tblcbo_" for lookup tables, "tbllnk_"
for many-many link tables, "tbl_" for other tables. For other ideas,
try googling for "database naming conventions" - you'll get plenty of
reading material.

Ray Gurganus
Community IT Innovators
www.citidc.com
Jul 19 '05 #6
Ray
"Matthew Crouch" <ma************@spamlessverizon.net> wrote in message news:<uX*****************@nwrddc02.gnilink.net>...
Does anyone know where I could find a consensus (in mysql community) on
naming conventions? Is there a published standard? I mean primarily the
naming of tables and fields.

Obviously, people use what works for them. But I'd like a look at any hard
and fast rules that all or most people stick to.


If you're hosting the db on a case-sensitive file system, then table
names will be case-sensitive. For this reason, I prefer to always use
lowercase for all table names (and field names for consistency). Then
you don't have to remember what case to use when.

I normally use name prefixes of "tblcbo_" for lookup tables, "tbllnk_"
for many-many link tables, "tbl_" for other tables. For other ideas,
try googling for "database naming conventions" - you'll get plenty of
reading material.

Ray Gurganus
Community IT Innovators
www.citidc.com
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by David Inada | last post: by
reply views Thread by Matthew Crouch | last post: by
2 posts views Thread by Dibyendu Basu | last post: by
1 post views Thread by BillyTheKid | last post: by
4 posts views Thread by Mark Broadbent | last post: by
1 post views Thread by shsandeep | last post: by
9 posts views Thread by Pieter | last post: by
35 posts views Thread by Smithers | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.