naming standards

[Matthew Crouch]

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.

[Don Rota]

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.

[Don Rota]

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.

[Don Rota]

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.

[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

[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

[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