SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member maybeithink2much's Avatar
    Join Date
    Jul 2004
    Location
    Shreveport, LA
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Standardization?

    Is there a standard for MySQL similar to the C++ coding standard or the PHP coding standard?

    Specifically, is there a recommendation on how to name tables or columns?

    Just wondering...

  2. #2
    SitePoint Addict psyon's Avatar
    Join Date
    May 2004
    Location
    Cedar Rapids
    Posts
    295
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Not that I have ever seen. My general rule, is make it easy for myself (or others who might have to look at it) to understand what is going on.

  3. #3
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Yes, there are standards available to help you create a good database design. Do a search on "Database Design Standards" at your favorite search engine or pick up a book on ANSI SQL-92 to get a start.
    Wayne Luke
    ------------


  4. #4
    Non-Member
    Join Date
    Aug 2002
    Location
    USA
    Posts
    544
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Some people use Hungarian notation. I just give them description names.

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    wayne, no book on the ansi sql standard that i've seen has ever mentioned a standard for table and column names

    of course, i coulda missed it

    the convention i use is to name my tables in the plural, as a reminder that they are sets of rows, rather than container

    whatever you do, please do not name your tables like tblEmployees, tblCart, tblEtCetera

    if you do, i fully expect you also to name your columns colID, colName, colDescr, colNonsense

    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •