Mysql Naming Convention

Jonathan Ellis jonathan at
Tue Apr 18 20:49:27 MDT 2006

On Tue, 18 Apr 2006 19:38:59 -0600, "C. Ed Felt" <ed at> said:
>    In my upper level Computer Science Database Theory course we used two
>    text books: big fat, ugly ones.  Both used singular names for table
>    names.  It appears that the reasoning was because the table name
>    itself really represents each singular "entity" and there are just
>    multiple rows of them.

Wow, that is really bizarre logic.

Would you name an array "employee" because it is a single reference? 
that would be confusing: containers should be pluralized.
Similarly, a table contains multiple rows of a certain type.

All the code that I've seen that has been written by people who know
what they are doing pluralizes table names.  Even Fabian Pascal and
Joe Celko, who barely agree on anything else, agree on this much.

Worth checking out:

But I guess in the grand scheme of things, if singular table names is
your worst faux pas you're in pretty good shape. :)

C++ is history repeated as tragedy. Java is history repeated as farce.  --Scott McKay

More information about the PLUG mailing list