Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803

    Enumeration versus lookup tables

    Hi everyone. I am fairly new to mysql and have found a data type that may my life easier but am not sure I am taking a shortcut.

    I use lookup tables quite often in my models and have found that "enum" will give me the same functionality without having all of those other lookup tables around.

    What would be the "correct" or the best option. Should I just use enum and forego the other tables?

    Thanks! Frank

  2. #2
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803
    Hey guys, was my question that far out in left field?

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    stay far away from the dreaded, evil ENUM

    the horror! the horror!

    do a search on "dreaded evil enum" for more info...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803
    Thanks for the reply r937. I will do a search on that now.

Posting Permissions

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