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]

Re: naming standards

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 FieldNamesThatL ookLikeThis.
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 JammingNamesInt oOneAnotherAcht ung!
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:
[color=blue]
> 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.[/color]

[Don Rota]

Re: naming standards

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 FieldNamesThatL ookLikeThis.
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 JammingNamesInt oOneAnotherAcht ung!
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:
[color=blue]
> 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.[/color]

[Don Rota]

Re: naming standards

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 FieldNamesThatL ookLikeThis.
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 JammingNamesInt oOneAnotherAcht ung!
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:
[color=blue]
> 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.[/color]

[Ray]

Re: naming standards

"Matthew Crouch" <matthew.crouch @spamlessverizo n.net> wrote in message news:<uXR1b.591 1$081.1399@nwrd dc02.gnilink.ne t>...[color=blue]
> 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.[/color]

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

https://www.citidc.com

[Ray]

Re: naming standards

"Matthew Crouch" <matthew.crouch @spamlessverizo n.net> wrote in message news:<uXR1b.591 1$081.1399@nwrd dc02.gnilink.ne t>...[color=blue]
> 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.[/color]

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

https://www.citidc.com

[Ray]

Re: naming standards

"Matthew Crouch" <matthew.crouch @spamlessverizo n.net> wrote in message news:<uXR1b.591 1$081.1399@nwrd dc02.gnilink.ne t>...[color=blue]
> 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.[/color]

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

https://www.citidc.com